Friday, February 13, 2009

To retrive source code of database objects in oracle

The user_source view provides the source code of the named objects in the user schema. One can get the source code for the object by issuing

SET LINES 1200
SET PAGES 1200
SELECT TEXT FROM USER_SOURCE WHERE NAME='object_name';

No comments: