Query user_sequences table : USER_SEQUENCES « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. USER_SEQUENCES

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

 

Related examples in the same category