PLS_INTEGER数据类型与PL / SQL中的SIMPLE_INTEGER数据类型有何不同? [英] How do PLS_INTEGER datatypes differ from SIMPLE_INTEGER datatype in PL/SQL?
问题描述
如何在pl / sql中区分这两种数据类型。我有一些选择,我必须通过它来区分它们。
1)PLS_INTEGER在没有哈希转换的情况下不能直接对它们执行算术运算。
2)PLS_INTEGER使用十六进制算法导致性能降低。
3)PLS_INTEGER仅与pl一起使用/ sql tables。
4)PLS_INTEGERs的范围从-32767到32768.
5) PLS_INTEGER在计算溢出时引发异常。
RTFM ...
引用:在11g中,引入了新的数据类型SIMPLE_INTEGER
Quote:两者之间的基本区别是SIMPLE_INTEGER始终为NOT NULL。
Quote:另一个区别是SIM卡PLE_INTEGER数据类型比PLS_INTEGER提供了更大的性能提升......
https://decipherinfosys.wordpress.com/2008/03/13/a-new-data-type-in-oracle-11g-simple_integer/ [ ^ ]
How can I differ this two datatypes in pl/sql. I have some choices regarding this, through which I have to differ them.
1) PLS_INTEGERs cannot have arithmetic operations performed directly on them without a hash conversion.
2) PLS_INTEGERs use Hex arithmetic resulting in reduced performance.
3) PLS_INTEGERs are only used in conjunction with pl/sql tables.
4) PLS_INTEGERs are renge restricted from -32767 to 32768.
5) PLS_INTEGERs raise an exception on calculation overflows.
RTFM...
Quote:In 11g, a new data type SIMPLE_INTEGER has been introduced
Quote:The basic difference between the two is that SIMPLE_INTEGER is always NOT NULL.
Quote:Another difference is that the SIMPLE_INTEGER data type gives major performance boost over PLS_INTEGER...
https://decipherinfosys.wordpress.com/2008/03/13/a-new-data-type-in-oracle-11g-simple_integer/[^]
这篇关于PLS_INTEGER数据类型与PL / SQL中的SIMPLE_INTEGER数据类型有何不同?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!