$ 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