Re: Can a do a "DESCRIBE <tablename>" from OCI?

"Ramon F Herrera" <ramon_at_conexus.net> wrote in message news:c9bc36ff.0411282342.e6a8b6a_at_posting.google.com...
> I am writing a program whose purpose is to create .dat
> files which are going to be used later by SQL*Loader.
>
> I would like my program to find out in real time whether
> any of the fields that are going to be inserted in the
> table are too wide.
>
> Therefore, I would like to have my OCI program connect to
> the database an perform some sort of "DESC tablename"
> command or equivalent. Perhaps I should perform a
> SELECT FROM USER_TABLES?
>
> TIA,
>
> -Ramon F Herrera

Maybe you could use DBMS_METADATA.GET_DDL ?

Example :
select dbms_metadata.get_ddl('table','dept','scott') from dual;

Matthias Received on Mon Nov 29 2004 - 12:44:20 CST