I don't have it in front of me, but I know that there are several SQL scripts out there that can duplicate the results of the SQL*Plus DESCRIBE command. Google for "oracle +describe" and you find a bundle.
HTH, Mike -----Original Message----- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Monday, April 18, 2005 11:10 AM To: Mike Scott; [email protected] Subject: RE: Describe <table> Describe is a SQL*Plus command, not SQL. If you want to see the columns and data types in a table, select from either DBA_TABLES, ALL_TABLES, or USER_TABLES. ----------------- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: Mike Scott [mailto:[EMAIL PROTECTED] Sent: Monday, April 18, 2005 11:50 AM To: [email protected] Subject: Describe <table> I'm using DBI and DBD::Oracle. I'd like to be able to describe a table, but 'describe table' fails no matter how I try to pass it to DBI. I feel certain that this is a FAQ and so apologise in advance. I have tried to track down an answer, but "describe" and "table" are hard words to seach for. Can anyone help me out? I just want the info describing the table that I can see in sqlplus. Mike Scott QA Software Developer BBC News Interactive White City London UK +44 20875 27288 http://www.bbc.co.uk/ This e-mail (and any attachments) is confidential and may contain personal views which are not the views of the BBC unless specifically stated. If you have received it in error, please delete it from your system. Do not use, copy or disclose the information in any way nor act in reliance on it and notify the sender immediately. Please note that the BBC monitors e-mails sent or received. Further communication will signify your consent to this. This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
