I want to use merge command to load data frequently. But I am not sure how it compares to SQL*Loader? the basic idea is to generate a script file for merging and execute it through SQL*PLUS. previously, this task is handled by SQL*LOADER, it is very tedious to generate the input/control files for sql*Loader and difficult to monitor the progress.
Any comments would be appreciated.