Ads Top

List all Stored Procedures from Oracle Database

  1. SELECT * FROM User_Procedures;
  2. SELECT * FROM DBA_Procedures; 
  3. SELECT * FROM User_Source WHERE name = 'stored_proc';
  4. SELECT * FROM DBA_Source WHERE name = 'stored_proc';

No comments:

Powered by Blogger.