SQL> select *from all_users; USERNAME -------------------------------------------------------------------------------- USER_ID CREATED COM O ---------- -------- --- - OPNUS 106 13-11-30 NO N SCOTT 102 13-09-30 NO N DVF 99 13-06-28 YES Y USERNAME -------------------------------------------------------------------------------- USER_ID CREATED COM O ---------- -------- --- - APEX_040200 98 13-06-28 YES Y APEX_PUBLIC_USER 95 13-06-28 YES Y FLOWS_FILES 94 13-06-28 YES Y USERNAME -------------------------------------------------------------------------------- USER_ID CREATED COM O ---------- -------- --- - LBACSYS 92 13-06-28 YES Y SPATIAL_CSW_ADMIN_USR 90 13-06-28 YES Y SPATIAL_WFS_ADMIN_USR 87 13-06-28 YES Y USERNAME -------------------------------------------------------------------------------- USER_ID CREATED COM O ---------- -------- --- - MDDATA 85 13-06-28 YES Y OLAPSYS 82 13-06-28 YES Y DVSYS 1279990 13-06-28 YES Y USERNAME -------------------------------------------------------------------------------- USER_ID CREATED COM O ---------- -------- --- - SI_INFORMTN_SCHEMA 78 13-06-28 YES Y ORDPLUGINS 77 13-06-28 YES Y ORDDATA 76 13-06-28 YES Y USERNAME -------------------------------------------------------------------------------- USER_ID CREATED COM O ---------- -------- --- - ORDSYS 75 13-06-28 YES Y CTXSYS 73 13-06-28 YES Y OJVMSYS 69 13-06-28 YES Y USERNAME -------------------------------------------------------------------------------- USER_ID CREATED COM O ---------- -------- --- - WMSYS 61 13-06-28 YES Y GSMCATUSER 60 13-06-28 YES Y MDSYS 79 13-06-28 YES Y USERNAME -------------------------------------------------------------------------------- USER_ID CREATED COM O ---------- -------- --- - ANONYMOUS 50 13-06-28 YES Y XDB 49 13-06-28 YES Y APPQOSSYS 48 13-06-28 YES Y USERNAME -------------------------------------------------------------------------------- USER_ID CREATED COM O ---------- -------- --- - DBSNMP 47 13-06-28 YES Y ORACLE_OCM 36 13-06-28 YES Y DIP 23 13-06-28 YES Y USERNAME -------------------------------------------------------------------------------- USER_ID CREATED COM O ---------- -------- --- - GSMUSER 22 13-06-28 YES Y GSMADMIN_INTERNAL 21 13-06-28 YES Y XS$NULL 2147483638 13-06-28 YES Y USERNAME -------------------------------------------------------------------------------- USER_ID CREATED COM O ---------- -------- --- - OUTLN 13 13-06-28 YES Y SYSKM 2147483619 13-06-28 YES Y SYSDG 2147483618 13-06-28 YES Y USERNAME -------------------------------------------------------------------------------- USER_ID CREATED COM O ---------- -------- --- - SYSBACKUP 2147483617 13-06-28 YES Y SYSTEM 8 13-06-28 YES Y AUDSYS 7 13-06-28 YES Y USERNAME -------------------------------------------------------------------------------- USER_ID CREATED COM O ---------- -------- --- - SYS 0 13-06-28 YES Y 37行が選択されました。 SQL> spool C:\temp\user.txt;