Re: please test on 8i

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Mon, 15 Dec 2003 05:31:52 -0600
Message-ID: <vtr6tg4cngu827@corp.supernews.com>

Tovalidate:

SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'; Session altered.

SQL> CREATE TABLE tbl (col date default '2041-01-21');

Table created.

SQL> insert into tbl values (default);
insert into tbl values (default)

                        *

ERROR at line 1:
ORA-00936: missing expression

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com
Author of: 'So You Want to be an Oracle DBA?'

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:3fdd6376$0$18692$afc38c87_at_news.optusnet.com.au...
>
> "Analysis&Solutions" <info_at_analysisandsolutions.com> wrote in message
> news:brjm6g$rtq$1_at_reader2.panix.com...
> > Greetings:
> >
> > I have access to a Oracle 9.2 server. The following queries run fine.
> > Can someone with access to a machine with some 8i version on it please
> > give the following a test and let me know what, if any, errors are
> > produced and which version you're using?
> >
> >
> > ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
> > CREATE TABLE tbl (col date default '2041-01-21');
> > insert into tbl values (default);
>
>
> I don't have 8i handy, but I'll tell you up front that you'd get an error
> here, because you can't explicitly reference the default value set for a
> column like this until 9i.
>
> Regards
> HJR
>
>
>
>
>
> > insert into tbl values ('2042-02-22');
> > insert into tbl values ('9999-12-31');
> > select * from tbl;
> > drop table tbl;
> >
> >
> > Thank you,
> >
> > --Dan
> > --
> > FREE scripts that make web and database programming easier
> > http://www.analysisandsolutions.com/software/
> > T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
> > 4015 7th Ave #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409
>
>
Received on Mon Dec 15 2003 - 05:31:52 CST