INT and number(22) in oracle DB tables
776852Feb 15 2011 — edited Feb 16 2011Hi Pros,
Recently I am doing the test about oracle data types,found a interesting problem, when I create a table like below
create table INT_TEST
(
ID int,
ID_1 number(22)
);
then insert as below
insert into INT_TEST values(540000000000000000000000000000000,5400000000000000000000);
it succeed, after several test, looks the int does not be constrined by number(22) as the column properties shows int equal number(22), so I am wondering what would be the root cause for this, please help.
thanks
Henry
Edited by: Henry He on Feb 16, 2011 11:24 AM
Edited by: Henry He on Feb 16, 2011 11:25 AM