Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: command to list all user tables
David Wright wrote:
> I have a list of tables but can't remember the command to print all the table
> names and their fields.
>
> Is there a command?
>
> I have three books on Oracle: Tuning, A beginers guide and DBA Handbook. Is
> there another book which just has "non-sql" sql commands?
select * from DBA|ALL|USER_TAB_COLUMNS Received on Mon May 03 2004 - 20:13:43 CDT
![]() |
![]() |