Re: Views vs. Tables

Hi,

Try this for the table EMPLOYEE:

select * from user_dependencies
where type='VIEW'
  and referenced_type='TABLE'
  and referenced_name='EMPLOYEE';

Andrew Protasov

> Any ideas on a sql statement that will list all views that reference a
> specific table name in Oracle 7?
Received on Tue Nov 10 1998 - 00:21:42 CST