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

xGss2000

1. Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
2. Connected as SYS
3. 
   
4. SQL>
5. SQL> DECLARE
6. 2 v_number NUMBER;
7. 3 v_pls PLS_INTEGER;
8. 4 v_binary BINARY_INTEGER;
9. 5 BEGIN
10. 6 v_number:=2147483647;
11. 7 v_pls :=2147483647;
12. 8 v_binary:=2147483647;
13. 9
14. 10 v_number:=v_number+1;
15. 11 v_number:=2147483647+1;-- ORA-01426: 数字溢出
16. 12 --v_number:=v_pls+1; -- ORA-01426: 数字溢出
17. 13 --v_number:=v_binary+1; -- ORA-01426: 数字溢出
18. 14 END;
19. 15 /
20. 
    
21. 
    
22. DECLARE
23. v_number NUMBER;
24. v_pls PLS_INTEGER;
25. v_binary BINARY_INTEGER;
26. BEGIN
27. v_number:=2147483647;
28. v_pls :=2147483647;
29. v_binary:=2147483647;
30. 
    
31. v_number:=v_number+1;
32. v_number:=2147483647+1;-- ORA-01426: 数字溢出
33. --v_number:=v_pls+1; -- ORA-01426: 数字溢出
34. --v_number:=v_binary+1; -- ORA-01426: 数字溢出
35. END;
36. 
    
37. ORA-01426: 数字溢出
38. ORA-06512: 在 line 12
39. 
    
40. SQL>
41. SQL> DECLARE
42. 2 v_number NUMBER;
43. 3 v_pls PLS_INTEGER;
44. 4 v_binary BINARY_INTEGER;
45. 5 BEGIN
46. 6 v_number:=2147483647;
47. 7 v_pls :=2147483647;
48. 8 v_binary:=2147483647;
49. 9
50. 10 v_number:=v_number+1;
51. 11 --v_number:=2147483647+1;-- ORA-01426: 数字溢出
52. 12 v_number:=v_pls+1; -- ORA-01426: 数字溢出
53. 13 --v_number:=v_binary+1; -- ORA-01426: 数字溢出
54. 14 END;
55. 15 /
56. 
    
57. DECLARE
58. v_number NUMBER;
59. v_pls PLS_INTEGER;
60. v_binary BINARY_INTEGER;
61. BEGIN
62. v_number:=2147483647;
63. v_pls :=2147483647;
64. v_binary:=2147483647;
65. 
    
66. v_number:=v_number+1;
67. --v_number:=2147483647+1;-- ORA-01426: 数字溢出
68. v_number:=v_pls+1; -- ORA-01426: 数字溢出
69. --v_number:=v_binary+1; -- ORA-01426: 数字溢出
70. END;
71. 
    
72. ORA-01426: 数字溢出
73. ORA-06512: 在 line 13
74. 
    
75. SQL>
76. SQL> DECLARE
77. 2 v_number NUMBER;
78. 3 v_pls PLS_INTEGER;
79. 4 v_binary BINARY_INTEGER;
80. 5 BEGIN
81. 6 v_number:=2147483647;
82. 7 v_pls :=2147483647;
83. 8 v_binary:=2147483647;
84. 9
85. 10 v_number:=v_number+1;
86. 11 --v_number:=2147483647+1;-- ORA-01426: 数字溢出
87. 12 --v_number:=v_pls+1; -- ORA-01426: 数字溢出
88. 13 v_number:=v_binary+1; -- ORA-01426: 数字溢出
89. 14 END;
90. 15 /
91. 
    
92. DECLARE
93. v_number NUMBER;
94. v_pls PLS_INTEGER;
95. v_binary BINARY_INTEGER;
96. BEGIN
97. v_number:=2147483647;
98. v_pls :=2147483647;
99. v_binary:=2147483647;
100. 
     
101. v_number:=v_number+1;
102. --v_number:=2147483647+1;-- ORA-01426: 数字溢出
103. --v_number:=v_pls+1; -- ORA-01426: 数字溢出
104. v_number:=v_binary+1; -- ORA-01426: 数字溢出
105. END;
106. 
     
107. ORA-01426: 数字溢出
108. ORA-06512: 在 line 14
109. 
     
110. SQL>