Re: newbie: dumb question
From: Mick McRae <Mick.McRae_at_its.csiro.au>
Date: Thu, 18 Jun 1998 13:45:06 +1100
Message-ID: <35888D42.261DB906_at_its.csiro.au>
Date: Thu, 18 Jun 1998 13:45:06 +1100
Message-ID: <35888D42.261DB906_at_its.csiro.au>
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?
>
> Thanks,
> Nathaniel
>
> nasand00_at_xxcslab.uky.edu
> remove the x's
Received on Thu Jun 18 1998 - 04:45:06 CEST