Contents

in:
  type: file
  path_prefix: '/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

2 entries across 2 versions & 1 rubygems

Version	Path
embulk-output-oracle-0.4.5	src/test/resources/yml/test-replace-oci-method.yml
embulk-output-oracle-0.4.4	src/test/resources/yml/test-replace-oci-method.yml