OraFAQ Forum: SQL & PL/SQL » dependency question

Home » SQL & PL/SQL » SQL & PL/SQL » dependency question

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dependency question [message #659262]

Tue, 10 January 2017 13:19

desmond30
Messages: 41
Registered: November 2009

Member

create table tab1(x number);

create or replace view v1
as 
select x from tab1;

create or replace view v2
as
select * from v1;

I am trying to write a query that given a table, gives me all the objects (directly and indirectly) dependent on the table

select *
FROM dba_dependencies
WHERE owner = 'MYSCHEMA'
AND referenced_name IN ('TAB1')

the above only gives me V1, what else need I write to get V2, and if V2 is used by is used by a package , then that package name and so on

Report message to a moderator