SQL> spool offSQL>
SQL> get c:\spooltest.log
1 SQL> select username,account_status from dba_users;
2 USERNAME ACCOUNT_STATUS
3 ------------------------------ --------------------------------
4 MGMT_VIEW OPEN
5 SYS OPEN
6 SYSTEM OPEN
7 DBSNMP OPEN
8 SYSMAN OPEN
9 SCOTT OPEN
10 HR OPEN
11 OUTLN EXPIRED & LOCKED
12 MDSYS EXPIRED & LOCKED
13 ORDSYS EXPIRED & LOCKED
14 EXFSYS EXPIRED & LOCKED
15 DMSYS EXPIRED & LOCKED
16 WMSYS EXPIRED & LOCKED
17 CTXSYS EXPIRED & LOCKED
18 ANONYMOUS EXPIRED & LOCKED
19 XDB EXPIRED & LOCKED
20 ORDPLUGINS EXPIRED & LOCKED
21 SI_INFORMTN_SCHEMA EXPIRED & LOCKED
22 OLAPSYS EXPIRED & LOCKED
23 TSMSYS EXPIRED & LOCKED
24 BI EXPIRED & LOCKED
25 PM EXPIRED & LOCKED
26 MDDATA EXPIRED & LOCKED
27 IX EXPIRED & LOCKED
28 SH EXPIRED & LOCKED
29 DIP EXPIRED & LOCKED
30 OE EXPIRED & LOCKED
31 已选择27行。
32* SQL> spool off
33
SQL>