RE: DESCRIBE?

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Mon, 28 Mar 2005 11:52:49 -0500
Message-ID: <001b01c533b6$93916150$2004a8c0@development.perceptron.com>

First, you can describe table, view, package..., but not database. Second, "describe" is SQL*Plus command (not SQL command), that's why it doesn't work in your Perl script.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Graeme St. Clair Sent: Monday, March 28, 2005 11:48 AM
To: oracle-l_at_freelists.org
Subject: DESCRIBE?

I understand there is a "DESCRIBE my_data_base" command in Oracle SQL, and I
assume it will return material describing the d-b in question. Right so far? If so, is it restricted in some way? I'm finding I can issue SELECT
from a Perl script but not DESCRIBE - I get ORA-00900: invalid SQL statement
(DBD: error possibly near <*> indicator at char 1 in '<*>DESCRIBE my_data_base').

Rgds, GStC.

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Mon Mar 28 2005 - 11:56:34 CST