Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Case sensitive Tablenames
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...Received on Fri Sep 12 2003 - 05:48:05 CDT
> > 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.
>
>