Sha256: 8313ca6e2018da04cbd4d5b00282efb0d14a5f36a090dd019182fb5e4f1675d6
Contents?: true
Size: 764 Bytes
Versions: 10
Compression:
Stored size: 764 Bytes
Contents
in:
type: filesplit
path: '/oracle/data/test1/test1.csv'
parser:
charset: UTF-8
newline: CRLF
type: csv
delimiter: ','
quote: ''
columns:
- {name: ID, type: string}
- {name: VARCHAR2_ITEM, type: string}
- {name: NVARCHAR2_ITEM, type: string}
- {name: INTEGER_ITEM, type: long}
- {name: NUMBER_ITEM, type: string}
- {name: DATE_ITEM, type: timestamp, format: '%Y/%m/%d'}
- {name: TIMESTAMP_ITEM, type: timestamp, format: '%Y/%m/%d %H:%M:%S'}
out:
type: oracle
host: #host#
database: #database#
user: #user#
password: #password#
table: TEST1
mode: insert_direct
insert_method: oci
column_options:
INTEGER_ITEM: {value_type: pass}
#driver_path: driver/ojdbc7.jar
Version data entries
10 entries across 10 versions & 1 rubygems