Your title mentioned SQR, is that what you want to use to accomplish the comparison? I would recommend using Application Engine instead. It will make your life a lot easier. You can create filelayout for your CSV files, read data in that way and populate some temp tables. When all done, you can then write a combination of SQL and peoplecode to pull and compare different data. You can read more about file layouts in the PeopleCode API Reference peoplebook under the File Class chapter.

Another way of doing this, is using Oracle External Tables feature to load the data in and perform your comparison. Using oracle's external table feature will save you from creating actual tables in the database to store your data.

Not sure what your file layouts are - same number of comma delimited fields? I simply use a compare tool that shows both files side by side and highlights the differences.

It's called Beyond Compare 2. Free trial version avail online. Worth the license though.

If you want to go that route, I have used UltraCompare. It is a powerful compare/merge application and not that expensive either.

UltraCompare is developed by the same company that is behind UltraEdit, IMO, the best text editor out there.

hi all,
i just want to compare two folders not files using an sqr,
is it possible to call beyond compare or exam diff tools via sqr,
if so pls let me know.

thanks,
vivek.s