Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Query user_sequences table

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