Re: Naming Tables & Columns

Gennady,

You can double quote your identifiers like so:

        CREATE TABLE "MixedCaseTableName" . . .

However, you will need to take extra caution when referencing the Data Dictionary since you will have a non-standard approach.

Caveat Emptor!

Cheers,
Rich

In article <37273988$0$19787_at_fountain.mindlink.net>,   "Gennady" <gennadyb_at_halcosoftware.com> wrote:
> Hello,
> I know that Oracle is not case sensitive but when
> I created table name like my_table I have got MY_TABLE.
> The same is with columns names.
> How can I manage upper / low case Oracle naming representation?
> I use PO8 under NT.
>
> Gennady.
>
>

--

Rich Goldkamp, Consultant, OCP		RJGoldka_at_dcss.com
Digital Consulting & Software Services	(504) 523-5005 x2736

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own