SQL>
SQL> SELECT sequence_name, increment_by,
2 DECODE(cycle_flag,'y',' cycle','n', 'nocycle', 'nocycle')
3 cycle_flag,
4 DECODE(order_flag,'y',' order','n', 'noorder', 'noorder')
5 order_flag,
6 max_value, min_value, cache_size, last_number
7 FROM user_sequences
8 where rownum < 50
9 ORDER BY sequence_name;
no rows selected