DBA Data[Home] [Help]

VIEW: SYS.CDB_SEQUENCES

Source

View Text - Preformatted

SELECT "SEQUENCE_OWNER","SEQUENCE_NAME","MIN_VALUE","MAX_VALUE","INCREMENT_BY","CYCLE_FLAG","ORDER_FLAG","CACHE_SIZE","LAST_NUMBER","PARTITION_COUNT","SESSION_FLAG","KEEP_VALUE","CON_ID" FROM CONTAINERS("SYS"."DBA_SEQUENCES")
View Text - HTML Formatted

SELECT "SEQUENCE_OWNER"
, "SEQUENCE_NAME"
, "MIN_VALUE"
, "MAX_VALUE"
, "INCREMENT_BY"
, "CYCLE_FLAG"
, "ORDER_FLAG"
, "CACHE_SIZE"
, "LAST_NUMBER"
, "PARTITION_COUNT"
, "SESSION_FLAG"
, "KEEP_VALUE"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_SEQUENCES")