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: confused

Re: confused

From: <ngroves_at_ndsuk.com>
Date: Fri, 21 May 1999 15:20:33 GMT
Message-ID: <7i3tju$um5$1@nnrp1.deja.com>


In article <3744EBC2.BB1916E9_at_india.hp.com>,   "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
>
>

Neither - all_source & all_triggers are views. - check out the table sys.dba_views

nigel groves

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Fri May 21 1999 - 10:20:33 CDT

Original text of this message

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