Well I know, that an SQL Server integer is best represented by NUMBER(10).
But sometimes I have migrate some maintenance scripts to Oracle and I wonder if I must carefully map integer to NUMBER(10) or if I can just use the ansi type integer in Oracle.
Is there any reason not to use integer?
I verified it against 10g.
create table BK_int_test( i_col integer, f_col float); insert into BK_int_test values (1, 1); insert into BK_int_test values (1.1, 1.1); Select * from BK_int_test;
I_COL F_COL ---------- ---------- 1 1 1 1,1 2 rows selected.
Thanks that saves a lot of work.
The short form
integer is supported as well.