Re: sqlplus describe command

Kirill Richine (kirill_at_cs.ualberta.ca) wrote:
: select table_name, column_name, column_type
: from {table I am looking for};

I found it, it's user_tab_columns;

Sorry, I don't have the documentation, so I used deductive method:

select object_name from all_objects where object_name like 'USER%';

and then by the name of the object, it was easy to figure.

Thanks.
k. Received on Wed Feb 19 1997 - 00:00:00 CET