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.

Explain the truncate in oracle?

906

---

How a database is related to tablespaces?

981

---

What is an oracle recycle bin?

929

---

How do I learn what codesets are available in oracle?

996

---

What is meant by joins?

1012

---

What are the differences between lov and list item?

989

---

How to convert a string to a date in oracle database?

999

---

How to get a list of all user accounts in the database?

1030

---

Does facebook use oracle?

977

---

What is the fastest query method to fetch data from the table?

1290

---

How to do paging with oracle?

948

---

interview questions with answer for cts

2531

---

Explain the use of control file?

1060

---

Respected sir, Please send me technical questions related to oracle apps..

1759

---

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

974

---