Query dba_users table : dba_users « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. dba_users

Query dba_users table

   
SQL>
SQL> set define off
SQL> set echo off
SQL> set linesize 78
SQL>
SQL> prompt User Information
User Information
SQL>
SQL> column username format a20 heading "Username"
SQL> column default_tablespace format a14 heading "Default Tblspc"
SQL> column temporary_tablespace format a10 heading "Temp Tblspc"
SQL> column locked format a1 heading "L"
SQL>
SQL> break on tblspc skip 1
SQL>
SQL> select username, default_tablespace, temporary_tablespace,
  2         decode( account_status, 'EXPIRED & LOCKED', '*',
  3                                 'OPEN', '' ) locked
  4    from dba_users
  5    where rownum < 50
  6  /
Username             Default Tblspc Temp Tblsp L
-------------------- -------------- ---------- -
JAVA2S               SYSTEM         TEMP
SYS                  SYSTEM         TEMP
SYSTEM               SYSTEM         TEMP
ANONYMOUS            SYSAUX         TEMP
MDSYS                SYSTEM         TEMP       *
OUTLN                SYSTEM         TEMP       *
DIP                  SYSTEM         TEMP       *
TSMSYS               SYSTEM         TEMP       *
FLOWS_FILES          SYSAUX         TEMP       *
CTXSYS               SYSAUX         TEMP       *
DBSNMP               SYSAUX         TEMP       *
FLOWS_020100         SYSAUX         TEMP       *
XDB                  SYSAUX         TEMP       *
HR                   USERS          TEMP       *

14 rows selected.

SQL> set define on
SQL>
SQL>
SQL> --

   
    
  

Related examples in the same category