Now iam migrating my system from SQL to ORACLE 9i.
The sql select query has the following code
CAST(0 as integer)
since Oracle doesnt have integer datatype , how should i change the above code??
should i use number datatype???
CAST( 0 as number) : Is this correct??? or should i use
CAST(0 as number(10,0))
Note: This CASTED value will be stored in a field that is of type INT