column default set does not work at table
592815Jan 17 2013 — edited Jan 18 2013Hi Experts,
I created a table have 3 columns. one column is PK and other column set default as 0.
create table test
(
id NUMBER(12) not null,
salary NUMBER(10,2) default 0.00,
hour NUMBER(10,2) default 0.00
);
when user insert value at MS access form. salary and hours are blank. insert processing works well.
But salary and hour column is null. default value 0.00 does not be put into column during inserted data.
We use oracle 11.2 at window 64 bit 2008.
any suggestion?
newdba