SyntaxFix

[oracle] Get a list of all functions and procedures in an Oracle database 

 SELECT * FROM all_procedures WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','PACKAGE') 
 and owner = 'Schema_name' order by object_name

here 'Schema_name' is a name of schema, example i have a schema named PMIS, so the example will be

SELECT * FROM all_procedures WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','PACKAGE') 
and owner = 'PMIS' order by object_name

enter image description here

Ref: https://www.plsql.co/list-all-procedures-from-a-schema-of-oracle-database.html

Examples related to oracle

• concat yesterdays date with a specific time • ORA-28001: The password has expired • how to modify the size of a column • How to create a blank/empty column with SELECT query in oracle? • Find the number of employees in each department - SQL Oracle • Query to display all tablespaces in a database and datafiles • When or Why to use a "SET DEFINE OFF" in Oracle Database • How to insert date values into table • error: ORA-65096: invalid common user or role name in oracle • In Oracle SQL: How do you insert the current date + time into a table?

Examples related to plsql

• How can you tell if a value is not numeric in Oracle? • Why do I get PLS-00302: component must be declared when it exists? • Split function in oracle to comma separated values with automatic sequence • PLS-00428: an INTO clause is expected in this SELECT statement • What is the max size of VARCHAR2 in PL/SQL and SQL? • PLS-00201 - identifier must be declared • Default Values to Stored Procedure in Oracle • How to call Oracle MD5 hash function? • Proper way of checking if row exists in table in PL/SQL block • PLS-00103: Encountered the symbol when expecting one of the following:

Examples related to oracle9i

• ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client • How to select only 1 row from oracle sql? • ORA-01008: not all variables bound. They are bound • Oracle PL/SQL - How to create a simple array variable? • ORA-12560: TNS:protocol adaptor error • ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function) • UTL_FILE.FOPEN() procedure not accepting path for directory? • Get a list of all functions and procedures in an Oracle database • Best way to do multi-row insert in Oracle?