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

Home -> Community -> Usenet -> c.d.o.tools -> Re: lower case character

Re: lower case character

From: Henning Steudle <armadillo_blue_at_yahoo.de>
Date: Wed, 10 Jan 2001 18:57:09 +0100
Message-ID: <3A5CA275.D3CCF595@yahoo.de>

Hi Lee,

it´s pretty simple. Just use double quotation marks when you name your table
i.e. CREATE TABLE "testschema"."test" (col1 VARCHAR2(10) NULL, col2 VARCHAR2(10) NULL) ; Thats all.

Have a nice day

Henning

Lee schrieb:

> Hi,
> Is it possible to give a name to your table and column which contain
> lowercase character in Oracle?
> Even if I typed in lower case when I create table using sqlplus it just
> convert to upper case when I use dbastudio to view the table.
>
> Thanks and best regards
> Lee
  Received on Wed Jan 10 2001 - 11:57:09 CST

Original text of this message

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