Re: how to list all tables in sqlplus
From: Matt B. <mcb_at_fightspam.sd.znet.com>
Date: Thu, 23 Nov 2000 12:09:18 -0800
Message-ID: <t1qu9ortgnb15c_at_corp.supernews.com>
Date: Thu, 23 Nov 2000 12:09:18 -0800
Message-ID: <t1qu9ortgnb15c_at_corp.supernews.com>
[Quoted] "Steve" <sfang88_at_yahoo.com> wrote in message
news:3A1D583E.ECDB6F05_at_yahoo.com...
> I tried "select table_name from dba_tables" but it says there is no table
> "dba_tables". What could other name be? Thanks Matt!
>
> Steve
No? Dang! That's weird. Maybe my brain is failing...
Try this:
select object_name
from dba_objects
where object_type = 'TABLE';
-Matt Received on Thu Nov 23 2000 - 21:09:18 CET