Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Dictionary View for Procedure Text

FlakeJan 16 2008 — edited Jan 16 2008

Hi,
Is there a data-dictionary where I can see the body of procedures. In fact, I received a request from a collegue to give him the procedure name which access a table "table_1".
So, my idea is to write a query as follows:

SELECT <procedure_name> FROM <data_dictionary> WHERE <text> LIKE '%table_1%'.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 13 2008

Added on Jan 16 2008

#general-database-discussions

4 comments

8,557 views