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. |
| Type |
The type of a column in a table. The valid values for the column type are listed below:  binary_double
This type is used to represent a 64-bit double-precision floating point number. In contrast to a float datatype which has decimal precision, a binary_double has binary precision. The binary_double also supports special values infinity and NaN (not a number). Maximum positive finite value: 1.79769313486231E+308 Minimum positive finite value: 2.22507485850720E-308 binary_float
This type is used to represent a 32-bit single-precision floating point number. In contrast to a float datatype which has decimal precision, a binary_float has binary precision. The binary_float also supports special values of infinity and NaN (not a number). Maximum positive finite value: 3.40282E+38F Minimum positive finite value: 1.17549E-38F blob
This type is used to represent a binary large object. The maximum size is (4 gigabytes – 1)*(database block size) The database block size is specified in bytes through the DB_BLOCK_SIZE value in Oracle, and can be 2048 (2KB) through 32768 bytes (32KB). 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 clob
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) The database block size is specified in bytes through the DB_BLOCK_SIZE value in Oracle, and can be 2048 (2KB) through 32768 bytes (32KB). 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, 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 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. json
This type is used to represent JavaScript Object Notation (JSON) documents. nchar
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. The default and minimum size is 1 character. nclob
This type is used to represent a character large object containing Unicode characters. The maximum size is (4 gigabytes – 1)*(database block size) The database block size is specified in bytes through the DB_BLOCK_SIZE value in Oracle, and can be 2048 (2KB) through 32768 bytes (32KB). number
This type is used to represent zero 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. number(width, decimal)
This type is used to represent a numeric with the specified width and precision. As an example, consider the value 123.89 being inserted:
nvarchar
This type is used to represent variable-length Unicode character string having a maximum length as specified. 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 character Minimum size: 1 character Maximum length: 4000 bytes raw
This type is used to represent raw binary data or byte strings of specified size. Maximum size: 2000 bytes 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. timestamptz
This type uses the default value of 6 (which is microseconds). Width: This type accepts a width fractional second option up to 1 nanosecond (for example, varchar2
This type is used to represent a variable-length character string with a specified limit. Maximum size: 4000 characters Minimum size: 1 character xmltype
This type is used to represent eXtensible Markup Language (XML) documents. |
| Index |
The type of index to create on the given column. The valid values for the index type are listed below: BTree: This type is used to create balanced tree (B-tree) indices. A B-tree index is an ordered list of values divided into ranges. By associating a key with a row or range of rows, B-trees provide excellent retrieval performance for a wide range of queries including exact match and range searches. Bitmap: This type is used to create bitmap indices. A bitmap index stores a bitmap for each index key. Each index key stores pointers to multiple rows. They are primarily designed for data warehousing or environments in which queries reference many columns in an ad hoc fashion. PrimaryKey: This type specifies that the column is a primary key for the table. Only one primary key is allowed per table. Unique: This type specifies that the column has a UNIQUE constraint. Note that these non-spatial indexes are created only on table creation. |