oracle number sequence 和 java.util.Long范围关系oracle sequence的取值范围是

oracle sequence的取值范围是                                                           

NOMAXVALUE SpecifyNOMAXVALUE to indicate a maximum value of 10²⁸-1 for an ascending sequence or -1 for a descending sequence. This is the default.

而sequence是一个number类型

则如果用sequence作自增主键的话,则主键类型要是number(n,0)

NUMBER [ (p [,s]) ]

Number having precision p and scales. The precisionp can range from 1 to 38. The scales can range from -84 to 127. Both precision and scale are in decimal digits. ANUMBER value requires from 1 to 22 bytes.

s表示小数点右边位数，主键的话定位0

而java定义主键属性的类型可以为Long

Long的取值范围是

MAX_VALUE

public static final long MAX_VALUE

A constant holding the maximum value a long can have, 2 ⁶³-1.

也就是说Long

2^63 = 9.2233720368548 * 10 ¹⁸

近似于Number(19,0)