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: Jamesacomb <jamesacomb_at_aol.com>
Date: 05 Apr 2001 15:29:08 GMT
Message-ID: <20010405112908.12759.00000550@ng-mk1.aol.com>

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 Thu Apr 05 2001 - 10:29:08 CDT

Original text of this message

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