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.
From: Reidy, Ron
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.
Array BioPharma, Inc.
From: Mike Scott
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.
QA Software Developer
BBC News Interactive
+44 20875 27288
This e-mail (and any attachments) is confidential and may contain
personal views which are not the views of the BBC unless specifically
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.