Hi,
I have a procedure u in dbms_jobs. How do I actually view the code other than using tools such as DBA studio or Quest?
Thanks,
Chucks
Printable View
Hi,
I have a procedure u in dbms_jobs. How do I actually view the code other than using tools such as DBA studio or Quest?
Thanks,
Chucks
select text from user_source where name='PROCEDURE_NAME'
HTH
Srini