Re: Lower Case for the Data Dictionnary

On a more positive note ;) you can
create table and column names
quoted, which gets the names into
the data dictionary as entered and
not folded to upper case.

However every query then has to quote
table and column names.

As a variant, if the system is already built, you could create a secondary schema
which uses this mechanism to create
views of the tables, converting as required.

--
Jonathan Lewis

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

For latest news of public appearances
See http://www.jlcomp.demon.co.uk

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.




Paul Drake wrote in message <3B833BED.B7FA7AA2_at_home.com>...


>Sybrand Bakker wrote:

>>

>> "dc" <gobills_at_videotron.ca> wrote in message

>> news:FdFg7.75559$sv1.1912502_at_wagner.videotron.net...

>> > Is there a variable I can set when creating the database in order to

have


>> > the definitions in the data dictionnary case sensitive. For example, a

>> > column name would be identified as   totalToDate   instead of

>> TOTALTODATE

>> > . The main reason for that is to convert attributes (coming from

classes)


>> > from a UML design into a database with the Java notation

>> > (upperCaseAndLowerCase).

>> >

>> > Thanks.

>> >

>> >

>>

>> There is not.

>>

>> Regards,

>>

>> Sybrand Bakker, Senior Oracle DBA

>

>sure there is:

>

>_Drive_DBA_iNsAnE=true

>

>followed by

>

>_duhveloper_breathing_timeout=60

>

>

>Paul