Mega Code Archive

 

Categories / Oracle PLSQL / SQL Plus

 

Use prompt to display information

SQL> SQL> SQL> prompt SQL> prompt This is a list of users and their default This is a list of users and their default SQL> prompt tablespaces tablespaces SQL> SQL> select username, default_tablespace   2    from dba_users   3    where rownum < 50   4  / USERNAME                       DEFAULT_TABLESPACE ------------------------------ ------------------------------ SYS                            SYSTEM SYSTEM                         SYSTEM ANONYMOUS                      SYSAUX MDSYS                          SYSTEM OUTLN                          SYSTEM DIP                            SYSTEM TSMSYS                         SYSTEM FLOWS_FILES                    SYSAUX CTXSYS                         SYSAUX DBSNMP                         SYSAUX FLOWS_020100                   SYSAUX USERNAME                       DEFAULT_TABLESPACE ------------------------------ ------------------------------ XDB                            SYSAUX HR                             USERS 13 rows selected. SQL> SQL>