| I want to generate sequence value on duplicate data [message #73383] |
Wed, 07 April 2004 05:21 |
spatemp
Messages: 8
Registered: April 2004
|
Junior Member |
|
|
I want to generate a sequnce value and replace it with the duplicate key value that is coming in from the file as sqlldr loads data. Is there a way to do that with sqlldr utility. So, in the example below I would want to replace 10 with unique sequence value and leave 20 and 30 alone. Thanks for help. The file is pretty large(10 million rows) so I am trying to avoid running a query later that would find duplicate rows and replace it with unique key.
Example:
Data:
10, George, Adams
10, Neil, Johnson
20, Merry, Sue
30, Sam, Martin
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
