Author: Dev

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’;

Display names of all constraints from Oracle database To display names of all constraints from Oracle database or from an specific table you can use: USER_CONSTRAINTS, ALL_CONSTRAINTS, DBA_CONSTRAINTS. Examples SELECT * FROM USER_CONSTRAINTS; SELECT * FROM USER_CONSTRAINTS WHERE OWNER=’SYSTEM’; SELECT * FROM USER_CONSTRAINTS WHERE OWNER=’SYSTEM’ AND TABLE_NAME=’USERS’; SELECT * FROM ALL_CONSTRAINTS; SELECT * FROM ALL_CONSTRAINTS…(Continue Reading)

Data Dictionary examples List all tables from a schema of Oracle database List all procedures from a schema of Oracle database List all triggers from Oracle database List all indexes from Oracle database Display names of all constraints from Oracle database Display names of all sequences from Oracle database Display names of all views from…(Continue Reading)

How to list all indexes from Oracle database To list all indexes from Oracle database or from an specific table you can use: USER_INDEXES, ALL_INDEXES, DBA_INDEXES, USER_OBJECTS. Privileges may be required to run some of the queries in the example below. Examples SELECT * FROM USER_INDEXES; SELECT * FROM USER_INDEXES WHERE TABLE_OWNER=’SYSTEM’; SELECT * FROM…(Continue Reading)

How to list all triggers from Oracle database To list all triggers from Oracle database you can query tables: USER_TRIGGERS, USER_TRIGGER_COLS, USER_OBJECTS, USER_PROCEDURES, ALL_PROCEDURES, DBA_PROCEDURES. Privileges may be required for certain queries. Examples SELECT * FROM USER_TRIGGERS ; SELECT * FROM USER_TRIGGER_COLS; SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE = ‘TRIGGER’; SELECT * FROM USER_PROCEDURES W…(Continue Reading)