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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: must table names be upper case

Re: must table names be upper case

From: Jim Conboy <Jim.Conboy_at_trw.com>
Date: Tue, 07 Nov 2000 11:43:43 -0800
Message-Id: <10673.121349@fatcity.com>


If you enclose the column name in quotes it will retain the case. = However, forever after any reference to that column must also be enclosed = in quotes and match the case exactly. I think you're just buying trouble = doing this.

Jim

>>> peter_at_schoenster.com 11/07/00 02:07PM >>>
Hi,

Whenever I create a table Oracle converts column names to upper=20 case. Is their a setting I can change to avoid this?

Thanks,

Peter



"Reality is that which, when you stop believing in it, doesn't go away".
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Nov 07 2000 - 13:43:43 CST

Original text of this message

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