シーケンス一覧を取得する
$ sqlplus '/ as sysdba' SQL> set line 256 SQL> set numwidth 32 SQL> col SEQUENCE_OWNER format a14 SQL> col CYCLE_FLAG format a10 SQL> col ORDER_FLAG format a10 SQL> spool scott_sequence.txt SQL> select * from all_sequences where sequence_owner = 'SCOTT' order by SEQUENCE_NAME; SQL> spool off