Re: ORACLE and QUOTE identifier

Article View: comp.lang.java.databases

Article #36

Back to comp.lang.java.databases Previous Next

#36

From: Lee Fesperman
Date: Thu, 02 Sep 1999 00:00

20 lines
1410 bytes

uncle.scrooge wrote:
> My problem is that I have legacy schema definitiions in sybase with
> lowercase column names.
> I want this same definitions to work with oracle. No problem you say?
> Oracle is case insensitive you say?

Oracle *is* case insensitive (as are all standard SQL RDBMSs). One of the purposes of 
quoting an identifier is to require case sensitivity. So, "CapitalIdea!" is distinct 
from "capitalidea!".

If your app says,

  insert into foo ("x", 100)

Try (if you can) defining the table this way...

  create table foo ("x" number)

--
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)

Technical Details

Message-ID: <37CF3C12.703@ix.netcom.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <37CF1CE6.711D5F04@worldnet.att.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10fec3,431bbdfd88a4a1f
X-Google-Attributes: gid10fec3,public
X-Google-Thread: 1073da,431bbdfd88a4a1f
X-Google-Attributes: gid1073da,public
X-Google-Thread: 107d46,431bbdfd88a4a1f
X-Google-Attributes: gid107d46,public
From: Lee Fesperman <firstsql@ix.netcom.com>
Subject: Re: ORACLE and QUOTE identifier
Date: 1999/09/02
Message-ID: <37CF3C12.703@ix.netcom.com>
X-Deja-AN: 520453530
Content-Transfer-Encoding: 7bit
References: <37CF1CE6.711D5F04@worldnet.att.net>
Content-Type: text/plain; charset=us-ascii
Organization: FFE Software, Inc.
X-NETCOM-Date: Thu Sep 02 10:18:28 PM CDT 1999
Mime-Version: 1.0
Newsgroups: comp.lang.java.databases,comp.databases.oracle,borland.public.jbuilder.database

Reply to Parent Message