| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Using Describe Outside of SQL Plus
I see this all the time when someone asks how to do a describe across a
database link. Either way, the answer is the same, you can query the
DBA_TAB_COLUMNS (or USER_TAB_COLUMNS) view and get all the information
that the describe command gives you.
HTH,
Brian
wax_man_at_my-deja.com wrote:
>
> Can describe be used outside of sql plus? I was trying to use it via
> odbc and Access to look at some table but it did not seem to work. I
> just get an 'odbc call failed' - '00900-invalid sql statement'.
>
> Can this be made to work?
>
> TIA
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
--
 |
 |