How can one skip any number of rows while loading the DB
tables with SQL Loader? Similarly how can one skip any
column?

Answer Posted / harikanth

LOAD DATA
INFILE 'Fullalbum.csv'
truncate
INTO TABLE DP_fa
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(
field2 FILLER,--for skipping the first column
sno,
performance_ky,
performance_nm,
isrc,
track_media_ky,
song_nm,
full_album,
country_nm,
isrc_country_cd
)

here first column will be skipped.

if you want to skip number of rows do the following
in cmd prompt
enter the commands like...
sqlldr <username>/<password>@<databasename>
cotrol='<location of control file>' skip=n<number of rows
that you want to skip>

Thanks,
Harikanth.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a procedure in oracle?

792


Is insert autocommit in oracle?

804


How to establish administrator authentication to the server?

787


How to create a table interactively?

755


How to convert characters to times in oracle?

770


What happens to the current transaction if the session is killed?

758


Can we write dml statement in function in oracle?

833


Where do you use decode and case statements?

760


Explain a data segment?

849


Explain the use of compress option in exp command.

751


What is oracle and what are its different editions?

796


How to rename an index?

808


Are truncate and delete commands same? If so why?

848


Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1609


How to create a new table by selecting rows from another table?

836