Skip to content

Instantly share code, notes, and snippets.

@nexocentric

nexocentric/Oracle SQL: List Stored Procedures

Created September 29, 2014 13:18
Show Gist options
  • Save nexocentric/da95e3288730fbe0552b to your computer and use it in GitHub Desktop.
Save nexocentric/da95e3288730fbe0552b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Oracle SQL: List Stored Procedures
--------------------------------------------------------
-- list all known stored procedures in oracle
--------------------------------------------------------
SELECT
owner,
object_name
FROM
dba_objects
WHERE
object_type = 'PROCEDURE'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment