Re: Object Dependencies -- How to search for a sub string ?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sat, 27 Jun 1998 19:00:30 GMT
Message-ID: <359940ee.5598119@192.86.155.100>

A copy of this was sent to "SRINIVAS CHIKKA" <SCHIKKA_at_worldnet.att.net> (if that email address didn't require changing) On Sat, 27 Jun 1998 13:40:19 -0400, you wrote:

>Hi,
>
> I have to develop a package that is used for object dependency analysis.
>Given a table name, I should list all the objects that are dependent on it.
>I have developed packaged procedures to list the index names, index columns
>and triggers that are defined on the table.
>
> I have problems finding out what packages or stored procedures and
>functions and views are dependent on the table.
>
> I am trying to search for the table name from user_views.text
>But it being a long column, I can not use SUBSTR or INSTR on it.
>Is there a way to see what views are based on the table ?
>
> Similarly, how to find out what packages or stored procs and funcs refer
>this table ?
>

1 select name, type
2* from user_dependencies where referenced_name = 'EMP' SQL> /

NAME                           TYPE
------------------------------ ------------
DEPT_EMP                       VIEW
REBUILD_EMP_TABLE              PROCEDURE

....

user & all_dependencies may be of some help here...

>I have to do it thru a package.
>
>Any ideas are of great help.
>
>Thanks in Advance,
>Srinivas.Chikka.
>
>

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

http://govt.us.oracle.com/ -- downloadable utilities

Opinions are mine and do not necessarily reflect those of Oracle Corporation

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sat Jun 27 1998 - 14:00:30 CDT