Re: Can't describe table!

chuckh_at_ix.netcom.com (Chuck Hamilton) wrote:

>richard_avery_at_nt.com (Richard Avery) wrote:
 

>>In article <40b7ja$lva_at_ixnews3.ix.netcom.com>, chuckh_at_ix.netcom.com (Chuck
>>Hamilton) wrote:
 

>>> There's a table in my Oracle 7.1 database with a lower case name. I
>>> can access the table just fine by enclosing the name in double quotes,
>>> but I can't DESCRIBE it to see the column names. How to I specify a
>>> lower case table name in a DESCRIBE command?
>>>
>>Try placing the table name in double quotes.
 

>>desc "lower_table"

Update: I tried to do this from SQL*Plus for Windows and it didn't work. But it *DOES* work in SQL*Plus for HP-UX!

Trying to describe a table with lower case name in SQL*Plus for Windows...

SQL> desc "cashdis";
Illegal identifier.

Same command in SQL*Plus for HP-UX...

SQL> desc "cashdis";

 Name                            Null?    Type
 ------------------------------- -------- ----
 Company                                  VARCHAR2(4)
 Control_                                 NUMBER(10)
 check_                                   NUMBER(10)

Weird huh? I still don't have a way of doing this in Windows though.

Versions are as follows:

	SQL*Plus for Windows: 3.1.3.5.4
	SQL*Plus for HPUX   : 3.1.3.7.1

--
Chuck Hamilton
chuckh_at_ix.netcom.com

Incoming fire has the right of way!