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: Returning columns names in small letters

Re: Returning columns names in small letters

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 05 Apr 2001 22:36:14 -0700
Message-ID: <3ACD55CE.881FF69F@exesolutions.com>

He is correct. And if you do this you deserve what you get. Years of headaches.

Oracle has a standard and a wise person doesn't flaunt it.

Daniel A. Morgan

Jamesacomb wrote:

> If you create the table using lower case letters enclosed in quotes, then the
> column name will be stored in lower case. be careful though, any select/DML
> statement will have to use the column names ONLY in lower case, enclosed in
> quotes. Many third part software tools do that generate SQL do NOT support
> this. So it's probably not a good idea to do this...
  Received on Fri Apr 06 2001 - 00:36:14 CDT

Original text of this message

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