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 -> Re: default to case sensitive

Re: default to case sensitive

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 24 Dec 1998 22:49:22 GMT
Message-ID: <3686c4ce.11140639@192.86.155.100>


A copy of this was sent to "Ed Zappulla" <zap_at_injersey.com> (if that email address didn't require changing) On Thu, 24 Dec 1998 15:39:33 -0500, you wrote:

>Does anyone know if I can make oracle 8.0.4 default to case sensitive names?
>
>

No, if you want case preserved in identifiers you must quote them, eg:

create table "MyTable" ( "myColumn" int );  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/ -- downloadable utilities  



Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Dec 24 1998 - 16:49:22 CST

Original text of this message

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