NUMBER(3,-1)3不是数值的个数??怎么赋值1234得出的结果是1230。。这个是四个数哦。。
解决方案 »
- oracle创建控制文件时遇到ora-00911错误,怎么办?(在线等......)
- oracle中的正则表达式的奇怪问题regexp_replace
- oracle问题!急!
- Oracle8i和9i中PLSQL程序不同运行结果
- variable 和 declare 定义变量有何不同
- 用户A有100个表,为了让B对这100个表有权限,怎莫做?
- 数据库重新启动后改变了作业原先设定好的执行时间,作业时间会变成数据库启动的那个时间,请各位不吝赐教
- 初学oracle的困惑
- 100分大派送啊,一个DELETE SQL语句的小问题!
- 崩溃,dbms_output.put_line(sysdate);始终报错 ORA-00900: 无效 SQL 语句
- dbms.output.put_line
- oracle 的while 循环
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. If you specify an arithmetic expression whose value has an absolute value greater than or equal to 1.0 x 10126, then Oracle returns an error. Each NUMBER value requires from 1 to 22 bytes.Specify a fixed-point number using the following form:NUMBER(p,s)where:p is the precision, or the total number of digits. Oracle guarantees the portability of numbers with precision of up to 38 digits.s is the scale, or the number of digits to the right of the decimal point. The scale can range from -84 to 127.