Database Utilities (MOSC)

MOSC Banner

sql loader master-detail

edited Feb 26, 2016 4:00AM in Database Utilities (MOSC) 1 commentAnswered

Hi,

  I need to load a pipe delimited flat file containing denormalized data as shown below into a master - detail table.  I know how to call a database sequence to make the join between the two tables, but would like to know how to create the control file so that multiple detail records can be loaded for one master record.  For this example, let's say the name of the master table is master_tab and the name of the detail table is detail_tab and the name of the sequence is my_seq.  The data file would like very similar to the

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