SQL*Loader query

Hi,

[Quoted] I'm trying to use SQL*Loader to load some data into a table, say employee, but one of the data fields is in another table, say dept e.g.

Table employee:
empno ename deptno

1          bob     3
2          tom     1

Table dept:
deptno dname

1         dev
2         mis
3         hr

The data I have to load into employee is like 1 bob hr

so somehow when I see the "hr" I need to look it up in dept and actually insert "3" for deptno.

Is there any way to do this sort of thing?

Thanks in advance.
Nick Received on Wed Mar 28 2001 - 10:55:57 CEST