Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Views vs. Tables

Re: Views vs. Tables

From: DanHW <danhw_at_aol.com>
Date: 10 Nov 1998 03:03:09 GMT
Message-ID: <19981109220309.04644.00001847@ng64.aol.com>


>Any ideas on a sql statement that will list all views that reference a
>specific table name in Oracle 7?
>

I believe the system view USER_DEPENDENCIES will tell you what you need,

Dan Hekimian-Williams Received on Mon Nov 09 1998 - 21:03:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US