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.
