I 10 record in csv now I want to insert 8 record only using sql loder it is possible if yes then explain with code if possible
LOAD (records to load) Default: All records are loaded. LOAD specifies the maximum number of logical records to load (after skipping the specified number of records). No error occurs if fewer than the maximum number of records are found.
Alternatively you could just load everything and then delete the rows you dont need.