Re: please test on 8i

"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 - 01:32:04 CST