Re: Can't describe table!

From: <ericl_at_community.net>
Date: 1995/08/12
Message-ID: <40h8vg$iff_at_odin.community.net>#1/1

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

Let me know how it works Received on Sat Aug 12 1995 - 00:00:00 CEST