Case sensitive Tablenames
Hobo
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
sybr...@yahoo.com
By default ALL identifiers are in UPPERCASE. You can use lowercase
(you don't want that) by enclosing the identifier in "", like "lower
case table name"
This has nothing to do with init.ora parameters
Regards
Sybrand Bakker
Senior Oracle DBA
Mark D Powell
This might be a duplicate post. Google issued an error on my first
attempt, but sometimes the messages appear so apologies if two nearly
identical posts show up.
Horst, by default Oracle stores all object names in the rdbms
dictionary in upper case though it is possible to override this
behavior. If you need to work with mixed or lower case object names
see the article:
Help, I can't drop a table which I created in my Oracle database using
MS-Access ? at the cooperatve FAQ http://www.jlcomp.demon.co.uk/faq/
I did a search of the version 9 documentation for SQL_ATTR_MATADATA_ID
and METADATA but came up empty. Where did you find this parameter?
-- Mark D Powell --
Niall Litchfield
news:2687bb95.03091...@posting.google.com...
> I did a search of the version 9 documentation for SQL_ATTR_MATADATA_ID
> and METADATA but came up empty. Where did you find this parameter?
SQL_ATTR_METADATA_ID is an ODBC statement attribute, not an Oracle
parameter. I *suspect*, but may well be wrong, that it is entirely
irrelevant.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
kkrause
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" <ho...@bulla.de> wrote in message news:<3f5edd64$0$272$8869...@news.cneweb.de>...
Mark D Powell
Thanks, Niall.
Tanel Poder
> (you don't want that) by enclosing the identifier in "", like "lower
> case table name"
Yeah, this one is nice for example:
SQL> create table t (" " number);
Table created.
SQL> desc t;
Name Null? Type
---------------------------------------------------------- -------- -------
--
NUMBER
:)
Tanel.
Joel Garry
> "Hobo" <ho...@bulla.de> wrote in message news:<3f5edd64$0$272$8869...@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
>
> This might be a duplicate post. Google issued an error on my first
> attempt, but sometimes the messages appear so apologies if two nearly
> identical posts show up.
I've noticed google doing that a lot lately. I discovered it will
often work if you simply press the reload button, and then IIRC it
says it doesn't have form data and asks if you want to repost form
data. I suspect they are trying to reinvent the webcache wheel.
jg
--
@home.com is bogus. Heard a politician advocating the ballot
proposition to give undocumented aliens CA drivers licenses. He
basically was using a Big Brother argument - better to get them in the
system so we have their pictures and fingerprints, against the
argument that it makes it easier for terrorists to get fake
identities. Hmmmmm... Your Papersss, pleassse...
Anurag Varma
"Tanel Poder" <change_to_m...@integrid.info> wrote in message news:3f60db36$1...@news.estpak.ee...
I find this one funny:
On windows (where ^G is control-G):
create table "^G^G^G^G^G^G" (a number);
and then try select table_name from user_tables;
You should hear beeps
or when you try
create table "^Z" (a number);
.... it seems hung until you press enter.
of course .. don't try it at work.
:)
Anurag
Anurag
Noons
--
Cheers
Nuno Souto
wizo...@yahoo.com.au.nospam
"Anurag Varma" <av...@hotmail.com> wrote in message news:EE98b.4208$t14....@news01.roc.ny...
Noons
if you create one with " " as the name,
which one will show up first in
select table_name from user_tables order by table_name;
?
<d&r>
--
Cheers
Nuno Souto
wizo...@yahoo.com.au.nospam
"Tanel Poder" <change_to_m...@integrid.info> wrote in message news:3f60db36$1...@news.estpak.ee...
sybr...@yahoo.com
CONTROL-S and CONTROL-Q are XON and XOFF
Noons
> "Noons" <wizo...@yahoo.com.au> wrote in message news:<3f61a508$1$14558$afc3...@news.optusnet.com.au>...
> > I wonder what "^S" would do in Unix?
> >
> > > create table "^Z" (a number);
> > > .... it seems hung until you press enter.
> > >
> > > of course .. don't try it at work.
>
>
I know. What would happen if someone created
a table with that in the name?
;)
Tanel Poder
> a table with that in the name?
The table name could also consist of ANSI escape sequences which will
program your enter key to shutdown abort or "host rm -rf *" or similar :)
Tanel.