Re: Can't describe table!

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?

How did it get in there in the first place?

An alternative to describing it, would be to:

SELECT column_name, data_type, ....
FROM all_tab_columns
WHERE table_name = 'lower case name';

-- 
George Credland
Management and Administrative Computing Services
The University of Sheffield
email: g.credland_at_sheffield.ac.uk