Re: SQL commands

From: Rune Skaug <rune.skaug_at_trade.no.thanks>
Date: Thu, 5 Aug 1999 15:55:23 +0200
Message-ID: <9Hgq3.252$E%3.1706@news1.online.no>

Jerry Gitomer <jgitomer_at_hbsrx.com> wrote in message news:7oc0dv$5o1$2_at_autumn.news.rcn.net...
> Hi,
> Do you mean something like:
>
> SELECT table_name FROM all_tables WHERE table_name LIKE
> '%DBA%';
> and
> SELECT view_name FROM all_views WHERE view_name LIKE '%DBA%';
>
> You will need DBA privileges in order to access the DBA tables.

One simple SQL...

select object_name
from all_objects
where object_name like '%DBA%'
and object_type in ('TABLE','VIEW');

... will meet all your needs. :) Received on Thu Aug 05 1999 - 08:55:23 CDT