For information on the parameters in this dialog that are common to all readers, see:
For information on the parameters in this dialog that are common to all writers, see:
User attributes for this format are defined below.
| Name |
The name of the column to be written. Valid values for column name include any character string devoid of SQL-offensive characters and less than 32 characters in length. |
| Type |
The type of a column in a table. The valid values for the column type are listed below:
 char
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 date
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. float
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. integer
This type is used to represent signed integers with a decimal precision of 38 digits. number
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 10126. It supports a precision of up to 38 digits. smallint
This type is used to represent signed integers with a decimal precision of 38 digits. timestamp
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. varchar2
This type is used to represent a variable-length character string with a specified limit. Maximum size: 4000 characters Minimum size: 1 character |