Display names of all sequences from Oracle database

Display names of all sequences from Oracle database

To display names of all sequences from Oracle database you can use: USER_SEQUENCES, ALL_SEQUENCES, DBA_SEQUENCES, USER_OBJECTS.

Examples

  
SELECT * FROM USER_SEQUENCES;

SELECT * FROM ALL_SEQUENCES;

SELECT * FROM DBA_SEQUENCES;

SELECT * FROM USER_OBJECTS 
WHERE OBJECT_TYPE='SEQUENCE';

SELECT * FROM USER_OBJECTS 
WHERE OBJECT_TYPE='SEQUENCE' 
AND ORACLE_MAINTAINED='N';