LIST ALL STORED PROCEDURES

Nov 24, 2013 • guidedmissile

SELECT * FROM USER_PROCEDURES;

SELECT * FROM DBA_PROCEDURES;

SELECT * FROM USER_SOURCE WHERE NAME = 'STORED_PROC';

SELECT * FROM DBA_SOURCE WHERE NAME = 'STORED_PROC';