#1 19 Feb 2016 17:46

New Member
Registered: 19 Feb 2016
Posts: 1

Sql loader

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


#2 19 Feb 2016 17:59

Simon Sheppard
Super Administrator
Registered: 27 Aug 2005
Posts: 955

Re: Sql loader

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.

https://docs.oracle.com/cd/B19306_01/se … params.htm

Alternatively you could just load everything and then delete the rows you dont need.



Board footer

Powered by FluxBB