Author: Dev

How to list all functions from Oracle database To list all functions from Oracle database you can query: USER_PROCEDURES, ALL_PROCEDURES, DBA_PROCEDURES, USER_OBJECTS. Examples SELECT * FROM USER_PROCEDURES ; SELECT * FROM USER_PROCEDURES WHERE OBJECT_TYPE=’FUNCTION’; SELECT * FROM ALL_PROCEDURES WHERE OBJECT_TYPE=’FUNCTION’; SELECT * FROM DBA_PROCEDURES WHERE OBJECT_TYPE=’FUNCTION’; SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE=’FUNCTION’ AND ORACLE_MAINTAINED=’N’;

List all scheduler jobs from Oracle database Oracle PL/SQL provides several views that allow users to view and manage scheduled jobs within the database. To list all scheduler jobs from Oracle database you can use: USER_SCHEDULER_JOBS, ALL_SCHEDULER_JOBS, DBA_SCHEDULER_JOBS. USER_SCHEDULER_JOBS view displays all scheduled jobs that are owned by the current user. This view only shows…(Continue Reading)

Get names of all synonyms from Oracle database To get names of all synonyms from Oracle database or from an specific table you can use: USER_SYNONYMS, ALL_SYNONYMS, DBA_SYNONYMS, USER_OBJECTS. USER_SYNONYMS: This view contains information about the synonyms that have been created by the current user. It provides information such as the name of the synonym,…(Continue Reading)

Get names of all tablespaces from Oracle database To get names of all tablespaces from Oracle database you can use: USER_TABLESPACES, DBA_TABLESPACES. Examples SELECT * FROM USER_TABLESPACES; SELECT * FROM DBA_TABLESPACES;

Display names of all views from Oracle database To display names of all views from Oracle database you can use: USER_VIEWS, ALL_VIEWS, DBA_VIEWS, USER_OBJECTS. Examples SELECT * FROM USER_VIEWS; SELECT * FROM ALL_VIEWS; SELECT * FROM DBA_VIEWS; SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE=’VIEW’; SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE=’VIEW’ AND ORACLE_MAINTAINED=’N’;