As of Oracle 8.0.5, the DESCRIBE command was not part of the server code.
It was only supported by tools such as sqlplus.  I have not tried newer
versions of Oracle, but I notice that DESCRIBE is not in the SQL Reference
for 9i.  Here is a query that should work for you:

SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE
FROM USER_TAB_COLUMNS WHERE TABLE_NAME = ?
ORDER BY COLUMN_ID

Any reasonably complete documentation of Oracle's data dictionary should
describe additional columns you might want to include in your query.

-dpf-

-----------------------
David P. Fannin
Database Administrator                                  [EMAIL PROTECTED]
UM-Rolla Computing and Information Services      FAX (573) 341-4216
URL  http://www.umr.edu/~dpf                   PHONE (573) 341-4841
-----------------------


-----Original Message-----
From: Marius Keraitis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 7:00 AM
To: DBI Perl
Subject: Another1 problem with Oracle


Hillow,

i have a simple question: can I use SQL command DESCRIBE instead of SELECT
in
this case:

....connect..
my $oraSQL = qq/SELECT * FROM TABLENAME /;
....do something..
....disconnect..

Or maybe there is another way to get table column names?

Hope You undestood my problem..:)

Mario.

Reply via email to