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