SQL> desc dba_users;

desc dba_users; 名前 NULL? 型 ----------------------------------------- -------- ---------------------------- USERNAME NOT NULL VARCHAR2(30) USER_ID NOT NULL NUMBER PASSWORD VARCHAR2(30) ACCOUNT_STATUS NOT NULL VARCHAR2(32) LOCK_DATE DATE EXPIRY_DATE DATE DEFAULT_TABLESPACE NOT NULL VARCHAR2(30) TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30) CREATED NOT NULL DATE PROFILE NOT NULL VARCHAR2(30) INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30) EXTERNAL_NAME VARCHAR2(4000) PASSWORD_VERSIONS VARCHAR2(8) EDITIONS_ENABLED VARCHAR2(1) AUTHENTICATION_TYPE VARCHAR2(8)

SQL> select distinct account_status from dba_users;

select distinct account_status from dba_users;

ACCOUNT_STATUS

-------------------------------- OPEN EXPIRED & LOCKED

 

SQL> select username from dba_users where not account_status = 'OPEN';

USERNAME

------------------------------ SCOTT ORACLE_OCM XS$NULL BI PM MDDATA IX SH DIP OE APEX_PUBLIC_USER

USERNAME

------------------------------ HR SPATIAL_CSW_ADMIN_USR SPATIAL_WFS_ADMIN_USR FLOWS_FILES MDSYS ORDSYS EXFSYS WMSYS APPQOSSYS APEX_030200 OWBSYS_AUDIT

USERNAME

------------------------------ ORDDATA CTXSYS ANONYMOUS XDB ORDPLUGINS OWBSYS SI_INFORMTN_SCHEMA OLAPSYS OUTLN

31行が選択されました。

SQL>

 

本文转自健哥的数据花园博客园博客，原文链接：http://www.cnblogs.com/gaojian/p/3526900.html，如需转载请自行联系原作者