Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: confused
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
![]() |
![]() |