Re: Can't describe table!
From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1995/08/14
Message-ID: <40o0q3$pmg_at_ixnews2.ix.netcom.com>#1/1
Date: 1995/08/14
Message-ID: <40o0q3$pmg_at_ixnews2.ix.netcom.com>#1/1
ericl_at_community.net 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?
>>
>If you can access the table x
> would
>create view Y
>as select * from "x";
>work?
>Then you could just
>desc Y
That works. Thanks.
-- Chuck Hamilton chuckh_at_ix.netcom.com Incoming fire has the right of way!Received on Mon Aug 14 1995 - 00:00:00 CEST