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

Home -> Community -> Usenet -> c.d.o.misc -> Re: confused

Re: confused

From: David Russell <dbruce_at_kreative.net>
Date: Mon, 24 May 1999 23:40:44 GMT
Message-ID: <3749e333.16995888@news>

These are both views...

	Select * from tab 
	where tname in ('ALL_SOURCE','ALL_TRIGGERS') ;

David Russell

On Fri, 21 May 1999 10:44:42 +0530, "G.H VITTAL" <vittal_at_india.hp.com> wrote:

>If i say desc all_source or all_triggers oracle gives the column
>listing.
>If i say select table_name from dba_tables this objects all_trigger or
>all_source is not seen in the query ? If am confused whether these two
>objects are tables or synonymns ?
>
>regards
>vittal
>
>
>
>
>
Received on Mon May 24 1999 - 18:40:44 CDT

Original text of this message

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