How to load data using SQLLDR from multiple tables.(Urgent) [message #319603] |
Mon, 12 May 2008 06:29 |
gangaprasad.k
Messages: 3 Registered: May 2008
|
Junior Member |
|
|
Hi,
Assume that i have two tables tab1 and tab2.
I want to load the data into tab1 using data file "data1".
Their is one column in tab1 whose data is not available directly
in data file,whose value can found by combination of unique column in tab1(which is foreign key for tab2) and tab2.
Please help me to resolve the issue.
structure of tables
tab1
name dept_no dept_name
tab2
dept_no dept_name
here i want to load tab1(dept_name) from tab2(dept_no from tab1)
Here dept_name is not available in data file.
|
|
|
|
|
|
|
|
|