Re: ORACLE and QUOTE identifier

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)