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.
解决方案 »
- 关于一个SQL语句,困惑了,求指导
- DROP表后IMP表还能还原到DROP表之前的数据吗?
- 为什么count得不出正确的值
- 怎样写一个嵌套UPDATE语句?
- 跨数据库平台访问的设置问题
- 还有一个问题,在linux下,要对oracle9i进行数据备份,一定要启动Intelligent Agent吗?还有其他方式吗?
- 急请教PROCEDURE高手,在Object Browser里,我这个PROCEDURE为何总是建立不成?
- 我是新手,请问在UNIX系统下,如何使用ORACLE9i的一些工具?
- Oracle9i创建数据出错(坐等)
- C#代码实现远程备份服务器Oracle数据库
- ROWNUM的问题
- 两个问题.一是如何释放undo表空间?二是truncate一张表报错需要nowait
不是decimal digits么??
说的具体点好么??