Re: Case sensitive Tablenames

From: kkrause <kkrause_at_homesourcecapital.com>
Date: 10 Sep 2003 07:58:57 -0700
Message-ID: <8f31cf59.0309100658.6f1abd58@posting.google.com>

Horst,

If you absolutely must have a case-sensitive table name you need to wrap it in double-quotes, eg. create table "junk" ( id number) and each and every time you reference it you'll have to remember the double-quotes. IMHO, this is a really bad idea.

Also, this parameter you mention (SQL_ATTR_M[E]TADATA_ID), is an ODBC driver parameter, not something internal to Oracle.

HTH -Kevin

"Hobo" <hobo_at_bulla.de> wrote in message news:<3f5edd64$0$272$88693e94_at_news.cneweb.de>...
> Hello,
>
> at a customer db the setting for tablenames is set to only Capital letters.
> How can we manage this at our DB. We've found a parameter
> SQL_ATTR_MATADATA_ID???? Is it a hidden parameter for init,ora?
>
> Can anyone help?
>
> Thanks inadvance
>
> Horst
Received on Wed Sep 10 2003 - 09:58:57 CDT