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 is the difference between sharding and replication?

0 Answers  

---

When do you get a .pll extension in oracle? Explain its importance

0 Answers  

---

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

0 Answers  

---

Difference between cartesian join and cross join?

0 Answers  

---

In Oracle 10g, "g" Stands for what?

5 Answers   Mphasis,

---

what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?

1 Answers   Arrow Electronics,

---

what is a Nested Loop join?

0 Answers  

---

When do you get a .pll extension in oracle?

0 Answers  

---

What is an Index ?

2 Answers  

---

How to assign values to variables?

0 Answers  

---

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

0 Answers  

---

Use of an integrity constraint is better to validate data. Explain

0 Answers  

---