How to view the exisiting procedure in oracle 8i and how to describe the procedure.
Printable View
How to view the exisiting procedure in oracle 8i and how to describe the procedure.
from user_source, all_source, dba_source
desc procedure_name in sql*plus
Hi,
As Pando said, you can see it from User_Source, All_Source etc., but normally when you move your
application from development to production environment you should wrap the Pl/Sql stored objects, so that
others will not be able to see the source code of it.
Vijay.
Use a tool like TOAD or PLSQL-developer