SQL*Loader Puzzle

From: Mr. Matteo diTommaso <ditommm_at_aa.wl.com>
Date: 21 Sep 93 10:48:52 -0400
Message-ID: <1993Sep21.104852.1_at_aa.wl.com>

SQL*Loader Puzzle

I have data files in the following format: #####

       10 Accounting 20 Research   30 Finance    40 Marketing  50 Sales
       ------------- ------------- ------------- ------------- -------------
       EmpNo Ename   EmpNo Ename   EmpNo Ename   EmpNo Ename   EmpNo Ename   
           1 Jim         6 Phil       11 Harry      16 Dawn       21 Arnie
           2 Betty       7 Peter      12 Jill       17 John       22 Jack
           3 Melvin      8 Nora       13 Laurie     18 Carol      23 Greg
           4 Elvis       9 Kelly      14 Gerald     19 Simon      24 Gordon
           5 Jerome     10 Dave       15 June       20 Renee      25 Guido

Manager:  33 Bob        34 Jane       35  Marvin    36 Reese      37 Chris

#####

Which I need to load into the following Tables

      Emp                      Dept
---------------------    ----------------

Empno Ename Manager Deptno DeptName ------ ------ ------- ------- --------

 1     Jim    33         10      Accounting
 2     Betty  33         20      Research
 3     Melvin 33         30      Finance
 4     Elvis  33         40      Marketing
 5     Jerome 33         50      Sales
33     Bob               
      .
      .
      .

Is SQL*Loader capable of this complex a loading job? If not what could be used to load this information?

| Matteo diTommaso (ditommm_at_aa.wl.com) | |
| Ann Arbor, MI, USA | This space for rent. |
| Phone: (313) 996-7148 | |
| (Request full disclaimer via e-mail) | |
Received on Tue Sep 21 1993 - 16:48:52 CEST