Thanks Steve!
Regards
HJR
--
------------------------------------
Oracle insights at www.dizwell.com
------------------------------------
"Steve Ashmore" <sashmore_at_neonramp.com> wrote in message
news:vtr6tg4cngu827_at_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 - 12:41:35 CST
