Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: pl sql
mort wrote:
> I am wondering how to write a pl sql statement that will do 2 things
> find duplicates in a file based on 1 column. I want to write all
> duplicates to one table then put all non duplicates into another table
> in the same script
a. File size is small:
Read each line from the file and store all the columns as a row in a
pl/sql table.
Once you are done reading the file, take the first element and compare
with the first column of all the remaining rows.
b. File size is big:
Do the above, but instead of storing in a pl/sql table, create a temp
table.
-- bhogakReceived on Mon Nov 19 2001 - 22:00:51 CST