Tuesday, January 11, 2011

View Procedure Definition in SQL Plus

To view the procedure definition in SQL* Plus, do the following

1) If ownere of the procedure then execute
      Select text from user_source where name = <proc_name>;

2) If your are not the owner of the procdure then execute
      Select text from all_source where name = <proc_name>;

No comments:

Post a Comment