#1 19 Feb 2016 17:46

Ravindra
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

Offline

#2 19 Feb 2016 17:59

Simon Sheppard
Super Administrator
Registered: 27 Aug 2005
Posts: 874
Website

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.

Example
http://ss64.com/ora/syntax-sqlload.txt

Offline

Board footer

Powered by FluxBB