Re: Oracle 7.2

From: Thomas J Kyte <tkyte_at_us.oracle.com>
Date: 1996/04/10
Message-ID: <4kgmm6$hcs_at_inet-nntp-gw-1.us.oracle.com>#1/1

SES <sespltd_at_po.pacific.net.sg> wrote:

>Hi, I just install Oracle 7.2 Server on NT.
>I created a table and saved it.
>However when I viewed the table, I discovered that all the tablenames
>and fieldnames have changed into uppercase
>even when I specified them in lowercase.
>Can someone pls tell me how to get them in lowercase.
 

>thanks
>kt..
>Pls email your reply to sespltd_at_pacific.net

Thats the ANSI way....

To get mixed case or special characters into identifiers you would use " (double) quotes. For example:

create table "MixedCase"
( "Field 1 with Blanks" number,
....
)
/

Beware, to select from MixedCase you must again use quoted identifiers, for example:

select "Field 1 with Blanks" from "MixedCase";

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government

---

opinions and statements are mine and do not necessarily reflect the opinions of Oracle Corporation. Received on Wed Apr 10 1996 - 00:00:00 CEST