Re: Default Value

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 31 Mar 2008 22:25:59 +0200
Message-ID: <c43d9$47f13ac6$524b5c40$19447@cache4.tilbu1.nb.home.nl>

Alberto wrote:

>
> This problem is on integer data type column only.
>
> I suppose that there is a configuration value that is possible to
> modified but I don't know which and where.
>

try this, using SQL*Plus:

create table blah (

    col_1 number NOT NULL,
    col_2 number NOT NULL,
    col_3 number DEFAULT 2 NOT NULL,
    col_4 number)

/
insert into blah(col_1, col_2) values (1,2); select * from blah;

using 10.2.0.3, I got:
SQL> insert into blah(col_1, col_2) values (1,2);

1 row created.

SQL> select * from blah;

      COL_1 COL_2 COL_3 COL_4 ---------- ---------- ---------- ----------

          1 2 2

-- 

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up

Received on Mon Mar 31 2008 - 15:25:59 CDT