[原创]NUMBER PLS_INTEGER BINARY_INTEGER 溢出情况测试

Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Connected as SYS

SQL>
SQL> DECLARE
2     v_number NUMBER;
3     v_pls    PLS_INTEGER;
4     v_binary BINARY_INTEGER;
5  BEGIN
6     v_number:=2147483647;
7     v_pls   :=2147483647;
8     v_binary:=2147483647;
9
10     v_number:=v_number+1;
11     v_number:=2147483647+1;-- ORA-01426: 数字溢出
12     --v_number:=v_pls+1;     -- ORA-01426: 数字溢出
13     --v_number:=v_binary+1;  -- ORA-01426: 数字溢出
14  END;
15  /


DECLARE
v_number NUMBER;
v_pls    PLS_INTEGER;
v_binary BINARY_INTEGER;
BEGIN
v_number:=2147483647;
v_pls   :=2147483647;
v_binary:=2147483647;

v_number:=v_number+1;
v_number:=2147483647+1;-- ORA-01426: 数字溢出
--v_number:=v_pls+1;     -- ORA-01426: 数字溢出
--v_number:=v_binary+1;  -- ORA-01426: 数字溢出
END;

ORA-01426: 数字溢出
ORA-06512: 在 line 12

SQL>
SQL> DECLARE
2     v_number NUMBER;
3     v_pls    PLS_INTEGER;
4     v_binary BINARY_INTEGER;
5  BEGIN
6     v_number:=2147483647;
7     v_pls   :=2147483647;
8     v_binary:=2147483647;
9
10     v_number:=v_number+1;
11     --v_number:=2147483647+1;-- ORA-01426: 数字溢出
12     v_number:=v_pls+1;     -- ORA-01426: 数字溢出
13     --v_number:=v_binary+1;  -- ORA-01426: 数字溢出
14  END;
15  /

DECLARE
v_number NUMBER;
v_pls    PLS_INTEGER;
v_binary BINARY_INTEGER;
BEGIN
v_number:=2147483647;
v_pls   :=2147483647;
v_binary:=2147483647;

v_number:=v_number+1;
--v_number:=2147483647+1;-- ORA-01426: 数字溢出
v_number:=v_pls+1;     -- ORA-01426: 数字溢出
--v_number:=v_binary+1;  -- ORA-01426: 数字溢出
END;

ORA-01426: 数字溢出
ORA-06512: 在 line 13

SQL>
SQL> DECLARE
2     v_number NUMBER;
3     v_pls    PLS_INTEGER;
4     v_binary BINARY_INTEGER;
5  BEGIN
6     v_number:=2147483647;
7     v_pls   :=2147483647;
8     v_binary:=2147483647;
9
10     v_number:=v_number+1;
11     --v_number:=2147483647+1;-- ORA-01426: 数字溢出
12     --v_number:=v_pls+1;     -- ORA-01426: 数字溢出
13     v_number:=v_binary+1;  -- ORA-01426: 数字溢出
14  END;
15  /

DECLARE
v_number NUMBER;
v_pls    PLS_INTEGER;
v_binary BINARY_INTEGER;
BEGIN
v_number:=2147483647;
v_pls   :=2147483647;
v_binary:=2147483647;

v_number:=v_number+1;
--v_number:=2147483647+1;-- ORA-01426: 数字溢出
--v_number:=v_pls+1;     -- ORA-01426: 数字溢出
v_number:=v_binary+1;  -- ORA-01426: 数字溢出
END;

ORA-01426: 数字溢出
ORA-06512: 在 line 14

SQL>