Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can a do a "DESCRIBE <tablename>" from OCI?

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

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 29 Nov 2004 03:35:52 -0800
Message-ID: <92eeeff0.0411290335.3f2331a4@posting.google.com>


ramon_at_conexus.net (Ramon F Herrera) 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?
>

Perhaps you should... coupled with a select from user_tab_columns. DESC[RIBE] is a SQL*Plus command.

Regards
/Rauf Received on Mon Nov 29 2004 - 05:35:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US