quoted column names,

I have Oracle schema in which the tables are created with their column names quoted,
for example

like

create table number_test
("Number" varchar2(11));

but when I access the table like this

select number from number_test,

Oracle engine gives me an error
that "Invalid column name"

But when I issue the select statement

select "Number" from number_test ;
then it runs fine.

I am trying to figure out is there is any way that we can run the select query without having column name in quotes.

I can run query with quotes, but I need some help in Oracle Congiguaration that would Make oracle to give a positive response to my quries without quotes.

any assitence would be very helpful to me

thanks

Faheem

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 21 2000 - 19:35:57 CST