Re: newbie: dumb question
Date: Sat, 27 Jun 1998 05:42:22 GMT
Message-ID: <35948537.544941_at_news.idt.net>
Nathaniel,
Another way is
SELECT table_name FROM User_tables;
Some time ago I read that TAB would go away. It's now 3 years later and it's still around. The solution Mick gave also works fine but User_Tables can give you some other info about your tables.
Take care,
Hank Talbot
On Thu, 18 Jun 1998 13:45:06 +1100, Mick McRae <Mick.McRae_at_its.csiro.au> wrote:
>Nathaniel,
>
>To see a list of tables owned by the user you login to sqlplus as, try;
>
>select * from tab;
>
>or more specifically,
>
>select * from tab where tabtype = 'TABLE';
>
>Regards,
>Mick
>
>Nathaniel Sanders wrote:
>
>> In sqlplus, I know that you can use the _describe_ command to
>> list the attribute names/types in a given table.
>>
>> How can I get a list of all table names?
Received on Sat Jun 27 1998 - 07:42:22 CEST