Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: quoted column names,
Sounds like someone exported a table out of Access into Oracle. ODBC allows
you to quote everything and Access thinks this is the best way. Short of
using "'s in your select statement, and that is a pain. You will have to
drop and recreate the table.
Jim
<faheemrao_at_my-deja.com> wrote in message news:8vf7tt$k2i$1_at_nnrp1.deja.com...
>
>
>
>
> 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 Wed Nov 22 2000 - 08:44:25 CST