Oracle Spatial GeoRaster Feature Types: User Attributes

This type is used to represent a 64-bit double-precision floating point number.

In contrast to a float datatype which has decimal precision, abinary_doublehas binary precision. Thebinary_doublealso supports special values infinity and NaN (not a number).

Maximum positive finite value:1.79769313486231e + 308

最小正有限值：2.22507485850720E-308

This type is used to represent a 32-bit single-precision floating point number.

In contrast to a float datatype which has decimal precision, abinary_float.has binary precision. Thebinary_float.also supports special values of infinity and NaN (not a number).

Maximum positive finite value:3.40282E + 38F.

最小正有限值：1.17549E-38F

This type is used to represent a binary large object. The maximum size is

(4 gigabytes – 1)*(database block size)

数据库块大小以字节为单位指定DB_BLOCK_SIZEOracle中的值，可以是2048（2KB）到32768字节（32KB）。

This type is used to represent a fixed length character data of specified length. Oracle will pad the value with blanks to this length.

The number of characters that can be stored depends on the database character set used. This type is in bytes.

默认长度：1 byte

Maximum length:2000 bytes

This type is used to represent a character large object containing single-byte or multibyte characters. The maximum size is

(4 gigabytes – 1)*(database block size)

数据库块大小以字节为单位指定DB_BLOCK_SIZEOracle中的值，可以是2048（2KB）到32768字节（32KB）。

This type is used to represent a valid date in the range from January 1, 4712 BC to December 31, 9999 AD. It contains the year, month, day, hour, minute and second. It does not have fractional seconds or a time zone.

This type is used to represent signed floating point numbers, and is equivalent to a number column with a binary precision of 126 binary digits (which implies a decimal precision of 15 digits).

Oracle recommends thatbinary_float.或者binary_doublebe used instead of this type because they are more robust.

This type is used to represent signed integers with a decimal precision of 38 digits.

This type is used to represent fixed length character data of a specified width. This is a Unicode-only datatype. The width is specified in units of characters. The maximum length of a NCHAR column is 2000 bytes.

默认值和最小大小为1个字符。

This type is used to represent a character large object containing Unicode characters. The maximum size is

(4 gigabytes – 1)*(database block size)

数据库块大小以字节为单位指定DB_BLOCK_SIZEOracle中的值，可以是2048（2KB）到32768字节（32KB）。

This type is used to represent zero as well as positive and negative fixed numbers with absolute values from 1.0 x 10^-130（但不包括）1.0 x 10¹²⁶. It supports a precision of up to 38 digits.

This type is used to represent a numeric with the specified width and precision.

As an example, consider the value123.89被插入：

• If the column was specified asnumber(5,2), the value123.89将被存储。
• If the column was specified asnumber(5,1), the value123.9将被存储。
• If the column was specified as号码（4,2）, it would exceed the permitted precision and a null would be inserted.

此类型用于表示具有规定的最大长度的可变长度Unicode字符串。

The number of characters that can be stored depends on the database character set used. The width is specified in units of characters.

Default:1个性

Minimum size:1个性

Maximum length:4000 bytes

This type is used to represent raw binary data or byte strings of specified size.

Maximum size:2000 bytes

This type is used to represent signed integers with a decimal precision of 38 digits.

此类型用于代表日期，月份和日期值以及小时，分钟，第二个时间值。它可用于存储精确时间值。

分数秒'精度为6位。

此类型用于表示具有指定限制的可变长度字符串。

Maximum size:4000 characters

Minimum size:1个性

此类型用于表示可扩展的标记语言（XML）文档。