RE: DESCRIBE?
- From: "Igor Neyman" <ineyman@xxxxxxxxxxxxxx>
- To: <Graeme.St.Clair@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 28 Mar 2005 11:52:49 -0500
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@xxxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Graeme St. Clair
Sent: Monday, March 28, 2005 11:48 AM
To: oracle-l@xxxxxxxxxxxxx
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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
