Sha256: c6079bed00f1473c729ee934fd7d5679ae087bc662eb2d1ece08e68911da361d
Contents?: true
Size: 966 Bytes
Versions: 8
Compression:
Stored size: 966 Bytes
Contents
in:
type: file
path_prefix: '/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: localhost
database: TESTDB
user: TEST_USER
password: test_pw
table: TEST1
mode: replace
insert_method: oci
column_options:
VARCHAR2_ITEM: {type: 'VARCHAR2(6)'}
NVARCHAR2_ITEM: {type: 'NVARCHAR2(6)'}
INTEGER_ITEM: {type: 'NUMBER(4,0)'}
NUMBER_ITEM: {type: 'NUMBER(10,2)'}
DATE_ITEM: {type: 'DATE'}
TIMESTAMP_ITEM: {type: 'TIMESTAMP'}
#driver_path: driver/ojdbc7.jar
Version data entries
8 entries across 8 versions & 1 rubygems