Re: sqlplus describe command

From: Pierre BAR <s780406_at_student.ulg.ac.be>
Date: 1997/02/22
Message-ID: <330F25A8.39D5_at_student.ulg.ac.be>#1/1


Kirill Richine wrote:
>
> Hi!
>
> Could you tell me what table the sql*plus describe command draws from?
>
> I would like to use something like
>
> select table_name, column_name, column_type
> from {table I am looking for};
>
> My main goal is to list the column type using an sql command.
> is it possible?
> Thank you.
> k&

You can use the following tables :
USER_TAB_COLUMNS (your own columns)
ACCESSIBLE_COLUMNS
SYS.DBA_TAB_COLUMNS (if you have access to this view) Received on Sat Feb 22 1997 - 00:00:00 CET

Original text of this message