Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Case sensitive Tablenames

Re: Case sensitive Tablenames

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Fri, 12 Sep 2003 20:48:05 +1000
Message-ID: <3f61a508$0$14558$afc38c87@news.optusnet.com.au>


and now, without trying:
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
wizofoz2k_at_yahoo.com.au.nospam
"Tanel Poder" <change_to_my_first_name_at_integrid.info> wrote in message news:3f60db36$1_1_at_news.estpak.ee...

> > 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"
>
> Yeah, this one is nice for example:
>
> SQL> create table t (" " number);
>
> Table created.
>
> SQL> desc t;
> Name Null? Type
> ---------------------------------------------------------- -------- -------
> --
> NUMBER
>
> :)
>
> Tanel.
>
>
Received on Fri Sep 12 2003 - 05:48:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US