Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> HELP! QUOTED identifiers

HELP! QUOTED identifiers

From: uncle.scrooge <uncle.scrooge_at_worldnet.att.net>
Date: Thu, 02 Sep 1999 21:29:42 -0400
Message-ID: <37CF2486.428D5279@worldnet.att.net>

is there a way to set an oracle server so that both of these statements work?

insert into FOO ("X",100)
insert into FOO ("x",100)

if the table is defined as "create table FOO(X varchar2)" ?

The second statement gives an "invalid column name" error.

I'm wrestling a very large jdbc bear, and I'm looking for server side solutions.

I need to either disable quoted identifiers (so that the quoted character is not "), or find a magical
setting client or server side that will do this.

Oracle 8.0.4 on HP. Client on NT 4.0. Using thin driver. Received on Thu Sep 02 1999 - 20:29:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US