note 35939 deleted from function.ocidefinebyname by vincent

Note Submitter: Maxwell_Smart <at> ThePentagon <dot> com ---- >Be careful that Oracle uses ALL-UPPERCASE column-names, That is actually untrue. Oracle defaults to all uppercase names, *unless* the COLUMN is CREATEd in quotes, in which case, case is preserved, and the exact case passed much match, which means anything other than uppercase COLUMN names must be sent in quotes. For example CREATE TABLE A ("a" NUMBER, a NUMBER); The first COLUMN stays lowercase, the second becomes uppercase. As another example, CREATE TABLE A ("a" NUMBER); INSERT INTO A VALUES(1); SELECT a FROM A; SELECT "a" FROM A; The first SELECT will fail, because it defaults to uppercase which will *not* match the lowercase COLUMN name.