Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Alternative to DESCRIBE
SELECT *
FROM all_tab_columns
WHERE owner = user
AND table_name = 'the_table';
On 16.03.2005 16:34 Robert Wehofer wrote:
> Is there a possibility to select column names and column types of a table
> without using the command DESCRIBE?
>
> Robert
>
>
Received on Wed Mar 16 2005 - 09:36:32 CST