Equivalent of Number(38) in Oracle DB SQL?

Question

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)   
      

Answer 1

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.