Hi,
I am currently looking for the codes of all procedures. Is there a table which will stored all the procedures? If yes, which table? Thanks. :)
Printable View
Hi,
I am currently looking for the codes of all procedures. Is there a table which will stored all the procedures? If yes, which table? Thanks. :)
I guess, u can use ALL_SOURCE table.
Hi gsprince,
i think you are right!
mooks, you can also try DBA_SOURCE and make sure
you use 'text' instead of '*' and 'line number'.
like: select text, line number from
DBA_SOURCE
order by line number;
correct me if i'm wrong!
HTH,