Re: Coltype Undefined

From: Jon Yi <joycompu_at_yahoo.com>
Date: Thu, 19 Dec 2002 15:43:00 GMT
Message-ID: <8OlM9.49843$_S2.8099@nwrddc01.gnilink.net>

"Marc Zinzen" <mzinzen_at_genese.de> wrote in message news:3E0192FF.AB5A897C_at_genese.de...
> Hi
>
> What the hell is happening???
> Here 's what I do on an Oracle9.2 Database running Win2k
>
> create table Name ( one timestamp )
> select name, coltype, length from syscolumns where tbname = 'NAME'
>
> this is what i get:
>
> NAME COLTYPE LENGTH
> ------------------------------ --------- ----------
> ONE UNDEFINED 11
>
> How is that possible??
> What can I do???
>
> Marc
>

Use "date" not "timestamp". Received on Thu Dec 19 2002 - 09:43:00 CST