posted 17 years ago
Im new to oracle, and im trying to load some data from a dat file using the sql Laoder. My problem is i don't know how to write a control file which can load this data.
the dat file looks like this:
1234; tom, jones;
4567; d, Bowie;
8973; G, micael;
Now if my table has column "ID" and "Name" and i want to use a sequence to place self generated ID and ignore the ones on the dat file then import the names as they are from the dat file, how do i do this?
