Re: Can't describe table!

> chuckh_at_ix.netcom.com (Chuck Hamilton) writes:
> 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?
>
> I thought about renaming it to upper case but I really don't want to
> do that.
>
  

Have you tried creating a view?

create view Y
as select * from "x"

and then

desc Y

It seems like it ought to work.

Eric Received on Wed Aug 16 1995 - 00:00:00 CEST