Re: SQL Server 2000 Migrate to Oracle

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 28 Nov 2004 20:45:14 -0800
Message-ID: <73e20c6c.0411282045.1232f73e@posting.google.com>

"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:<41aa40bf$0$19161$cc9e4d1f_at_news-text.dial.pipex.com>...
> > (as in space character) table names?
> > Quite funny.
>
> I once got fed up with all the t1,t2 etc tables that get created for tests.
>
> SQL> select table_name from user_tables;
>
> TABLE_NAME
> ------------------------------
> ąt1
>
> :(

LOL! Obviously a non-C background programmer. Being a long time C user, I prefer:

Purr>create table "t++" (f1 number,f2 date); Table created.

Elapsed: 00:00:05.01
         ^^^^^^^^^^^

(don't you love that? God bless RAC...>
Purr>desc "t++"

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 F1                                                 NUMBER
 F2                                                 DATE

Received on Sun Nov 28 2004 - 22:45:14 CST