.edu>cc:
Sent by: Subject: Re: How to get the list of
tables used in a view?
of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: How to get the list of tables used in a view?
>Date: Thu, 12 Jul 2001 20:15:44 -0800
>
>Hi Ashoke,
>
>Under 817 you can use dba_dependencies - their may be other
ways as well.
>
>For example:
>
>SQL> create table a
Bruce,
Thanks for your useful reply,
Ashoke
>From: "Reardon, Bruce (CALBBAY)" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: How to get the list of tables used in a view?
>Date:
Rachel,
Thanks,
Ashoke
>From: "Rachel Carmichael" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: How to get the list of tables used in a view?
>Date: Fri, 13 Jul 2001 02:40:49 -08
On Thu, Jul 12, 2001 at 07:10:21PM -0800, ASHOKE MANDAL wrote:
> Is there any dictionary table/view where I can query the name of all the
> tables used by a particular view?
--
select text from all_views
===
Ray Stell [EMAIL PROTECTED
ject: Re: How to get the list of tables used in a view?
>Date: Thu, 12 Jul 2001 20:10:28 -0800
>
>ok its late but off the top of my head, dba_dependencies?
>
>this is only a guess, as I'm heading off to bed and didnt verify it at
>all :)
>
>joe
>ASHOKE MANDAL wrote:
>
get it from dba_source
-Original Message-
Sent: Friday, 13 July 2001 13:10
To: Multiple recipients of list ORACLE-L
Greetings,
Is there any dictionary table/view where I can query the name of all the
tables used by a particular view?
The way I do now is : Query the line containing
Ashoke,
Look in dba_dependencies (or user_dependencies) view.
Select related columns for type = 'VIEW' .
HTH,
Regards,
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
> -Original Message-
> From: ASHOKE MANDAL [SMTP:[EMAIL PROTECTED]]
> Sent: Thursd
Hi Ashoke,
Under 817 you can use dba_dependencies - their may be other ways as well.
For example:
SQL> create table a (a integer);
Table created.
SQL> create table b (b integer);
Table created.
SQL> create view ab as select * from a,b where a=b;
View created.
SQL> select * from dba_depend
ok its late but off the top of my head, dba_dependencies?
this is only a guess, as I'm heading off to bed and didnt verify it at
all :)
joe
ASHOKE MANDAL wrote:
>
> Greetings,
>
> Is there any dictionary table/view where I can query the name of all the
> tables used by a particular view?
>
>
10 matches
Mail list logo