You might also
SELECT * FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = 'WHATEVER';
NB: the table name must b in CAPS.
eg.
SELECT * FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = 'ALL_TAB_COLUMNS';
will tell you about itself. COLUMN_ID is the order of the columns
in the table, so order by that it you need.
Troy Clark wrote:
>
> From SQLPlus you would execute
> desc mytable;
> And it will show you the definition of the table (columns, types, etc.)
>
> There is tons of info available via the v$ and dba_ views.
>
> Dr. Jan Dieckmann wrote in message <376A5C3A.3844CFC4_at_psi.de>...
> >If you like to have more comfort try a tool like Hora 3. See
> >http://www.keeptool.com for a free trial version of Hora.
> >
> >regards Jan Dieckmann
> >
> >Clarence Hart Jr. wrote:
> >
> >> Hello
> >> I'm sorry for asking such a simple Q but I dont know how to do this....
> >>
> >> Q.
> >>
> >> How do you view the info such as datatypes or defined views and stuff
> >> from sqlplus.
> >>
> >> ( In SYBASE its sp_help database or tablename)
> >>
> >> What is it in ORACLE?
> >>
> >> Thanks
> >>
> >> Clarence Hart
> >> clh_at_ismd.ups.com
> >
> >
> >
Received on Mon Jun 28 1999 - 10:06:55 CDT
