SQL Loader Loading Options

Loading Options:  INSERT,  APPEND, REPLACE and TRUNCATE

Insert           :  Loads rows only if the target table is empty.

Append         :  Load rows if the target table is empty or not.

Replace         :  First deletes all the rows in the table and then load rows

Truncate        :  First truncates the table and then load rows.