I am trying to get Oracle SQL Data into Java JBDC.
What is the Java convert data type equivalent of Number(38) in Oracle? Is it BigInteger or Long?
create table Customers
(
Customer_id NUMBER(38)
Equivalent of Number(38) in Oracle DB SQL?
Viewed 390
1 Answers
long is not enough. It only have 19 decimals:
Maximum value = 2^63-1 = 9,223,372,036,854,775,807.
You need to use BigInteger. BigDecimal should also be fine.
Related