Interested to Buy Any Domain ? << Click Here >> for more details...
How can one skip any number of rows while loading the DB
tables with SQL Loader? Similarly how can one skip any
column?
- 1 Answers
- 3648 Views
- IBM, I also Faced
- E-Mail Answers
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 |
How to test null values?
What is an Oracle sequence?
How to check the oracle tns settings?
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
What are operators in oracle?
How to create an oracle testing table?
How can you merge two tables in oracle?
Is primary key indexed by default in oracle?
What are the different oracle database objects?
What is meant by recursive hints in oracle?
How to recover a dropped index?
What are the set operators union, union all, minus & intersect meant to do?
Oracle General 
