Re: SQL*Plus Question : DESCRIBE command

Teresa,

You can get the equivalent information (and more) by selecting from DBA_TABLES, DBA_VIEWS and DBA_TAB_COLUMNS. If the tables and views are all owned by the user running the SQL*Plus session, you can use USER_TABLES, USER_VIEWS and USER_TAB_COLUMNS.

DESCRIBE DBA_TABLES etc to decide on the info to include in your SELECT. Include COLUMN_ID from DBA_TAB_COLUMNS (or USER_TAB_COLUMNS) in your ORDER BY clause to list the columns in the same order as DESCRIBE.

Hope this does what you want.

Regards,
Mike

Teresa Mah wrote:
>
> Hi,
>
> How do you output the schema of all of your relations?
> (I know you can do them one by one with the DESCRIBE command, but
> can you output all of them at once with another command?)
>
> Thanks.
>
> Teresa
Received on Thu Nov 05 1998 - 03:46:50 CET