Answer / 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.

what are pseudocolumns?

4 Answers  

---

What is a partition in oracle?

0 Answers  

---

Can we create database in oracle using command line ?

0 Answers   MCN Solutions,

---

What is a parameter file in oracle?

0 Answers  

---

In the oracle version 9.3.0.5.0, what does each number shows?

0 Answers  

---

What is Parallel Server ?

3 Answers  

---

What is the function of Optimizer ?

1 Answers  

---

i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table

3 Answers  

---

what's query optimization and without use of IN AND Exist can we get another way data from query

0 Answers  

---

What is the relation of a user account and a schema?

0 Answers  

---

Explain the concept of the DUAL table.

2 Answers  

---

what is difference between where clause and having clause?

13 Answers  

---