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 corelated subqueries

1 Answers   Global Infotech,

---

What is an anonymous block?

0 Answers  

---

Explain overloading. Can functions be overloaded?

0 Answers  

---

Explain oracle data types with examples?

0 Answers  

---

What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index

1 Answers  

---

What are the uses of synonyms?

0 Answers  

---

What is Network Database link ?

1 Answers  

---

how to retrive xml data for using sql query?

3 Answers   IBM, TCS,

---

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

0 Answers  

---

How to use "in out" parameter properly?

0 Answers  

---

What happens to the data files if a tablespace is dropped?

0 Answers  

---

What is Partitions in Table ?

2 Answers   Atiric Software,

---