Ok Thanks. We are just looking for a datatype we can go with the number of digits.. So the numeric datatype goes with number of digits?? I just tried inserting a record and I think its allowing 18 digits. Please correct me if I am wrong.

If this is correct, we will use number(18) in Oracle.

Thanks.