Fix is Specifies that each record in the datafile is of fixed length 90
POSITION(*+12)可能是POSITION(*+2)吧,意思就是空两格以后的字符就是属于Koshin。ZONED data is in zoned decimal format: a string of decimal digits, one per byte,
with the sign included in the last byte. (In COBOL, this is a SIGN TRAILING field.)
The length of this field is equal to the precision (number of digits) that you specify.
The syntax for the ZONED datatype is:In this syntax, precision is the number of digits in the number, and scale (if
given) is the number of digits to the right of the (implied) decimal point. The
following example specifies an 8-digit integer starting at position 32:
sal POSITION(32) ZONED(8),The ZONED clause is used to indicate that the field is a zoned decimal number. The
precision field indicates the number of digits in the number. The scale field is
used to specify the location of the decimal point in the number. It is the number of
digits to the right of the decimal point. If scale is omitted, a value of 0 is assumed.
POSITION(*+12)可能是POSITION(*+2)吧,意思就是空两格以后的字符就是属于Koshin。ZONED data is in zoned decimal format: a string of decimal digits, one per byte,
with the sign included in the last byte. (In COBOL, this is a SIGN TRAILING field.)
The length of this field is equal to the precision (number of digits) that you specify.
The syntax for the ZONED datatype is:In this syntax, precision is the number of digits in the number, and scale (if
given) is the number of digits to the right of the (implied) decimal point. The
following example specifies an 8-digit integer starting at position 32:
sal POSITION(32) ZONED(8),The ZONED clause is used to indicate that the field is a zoned decimal number. The
precision field indicates the number of digits in the number. The scale field is
used to specify the location of the decimal point in the number. It is the number of
digits to the right of the decimal point. If scale is omitted, a value of 0 is assumed.
解决方案 »
- oralce11g数据库服务端字符集更改问题
- 这2个oracle字符集有什么区别,能通用吗
- SQL某一字段单元格里有重复的如何查询出来???
- oracle的存储过程,在另外一个用户下,怎么调用!新手提问,在线急等!
- Visual studio 2005支持Pro*C/C++吗?
- 各位帮忙看看这SQL脚本有什么蹊跷之处?
- SGA大小调高,PGA不变,高速缓存命中百分比下降?
- 请问如何使用UDL连接oracle9i阿?
- 我在线!在P4 XP上装ORACLE8.16NT企业版,装不上点了SETUP没有反应听说要改一个文件名字或者是下一个补丁,是什么 啊谢谢了
- Oracle 闪回问题
- ROWNUM的问题
- 两个问题.一是如何释放undo表空间?二是truncate一张表报错需要nowait
不是decimal digits么??
说的具体点好么??