Re: Case sensitive Tablenames

"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.
>
>

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 Received on Thu Sep 11 2003 - 20:51:32 CDT