Database Utilities (MOSC)

MOSC Banner

Unable to load data into multiple table

edited Dec 12, 2018 4:00AM in Database Utilities (MOSC) 1 commentAnswered

Hello Support,

I have a requirement where needs to load data from .csv file to multiple table.  we have oracle application 12.2 version and 12c database. for this i have creaated following database object.

-- Table creation

create table xxabc.xxabc_cust_bai2_fheader

(

fheader_id number,

record_code varchar2(10),

sender_id varchar2(10),

receiver_id varchar2(10),

creation_date varchar2(10),

creation_time number,

fiid     number,

rec_length  number,

block_size  number,

ver_number  number

);

create table xxabc.xxabc_cust_bai2_gheader

(

fheader_id number,

gheader_id number,

record_code varchar2(10),

receiver_id varchar2(10),

origin_id   varchar2(10),

status number,

value_date varchar2(10),

value_time varchar2(10),

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center