number类型的范围是多少? 定义表的时候比如number(4),那么它的最大值是9999若你什么都不写,那值的范围就是:NUMBER Datatype The NUMBER datatype stores zero as well as positive and negative fixed numbers with absolute values from 1.0 x 10-130 to (but not including) 1.0 x 10126.
select min(to_number(start)),max(to_number(end)) from table不知道是不是这个意思?
定义表的时候比如number(4),那么它的最大值是9999若你什么都不写,那值的范围就是:NUMBER Datatype
The NUMBER datatype stores zero as well as positive and negative fixed numbers with absolute values from 1.0 x 10-130 to (but not including) 1.0 x 10126.