This content has been marked as final. Show 6 replies
SELECT * FROM DBA_SOURCE
Edited by: Ramin Hashimzadeh on Mar 31, 2013 1:16 PM
SELECT * FROM ALL_SOURCE
I am really thankful to u for quick reply but I want only those functions and procedure created by me.
SELECT * FROM USER_SOURCE
You can always start with something like
select table_name from dictionary where instr(table_name,:search_substring) > 0
SELECT TEXT FROM DBA_SOURCE WHERE NAME='YOUR_PROCEDURE_NAME' ORDER BY LINE
I am using Oracle 8.0.5.Oh my.