Re: newbie: dumb question

From: Henry Talbot <talbot_at_idt.net>
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

Original text of this message