Hi friends,
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???

Ex:
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

Please help..