Writer Feature Type: User Attributes

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.

Default length: 1 byte

Maximum length: 2000 bytes

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. This type is equivalent to a number column with a binary precision of 126 binary digits, which implies a decimal precision of 15 digits.

Oracle recommends that binary_float or binary_double be 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 0 as well as positive and negative fixed numbers with absolute values from 1.0 x 10^-130 to (but not including) 1.0 x 10¹²⁶. It supports a precision of up to 38 digits.

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

This type is used to represent the year, month, and day values of date as well as hour, minute, second values of time. It is useful for storing precise time values.

The fractional seconds’ precision is 6 digits.

This type is used to represent a variable-length character string with a specified limit.

Maximum size: 4000 characters

Minimum size: 1 character