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.

How to apply filtering criteria at group level in oracle?

834

---

What is the Tune Query

2088

---

How to convert dates to characters in oracle?

799

---

What is oracle used for?

778

---

How can we delete duplicate rows in a table?

760

---

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1599

---

What are the differences between date and timestamp in oracle?

818

---

State all possible different index configurations a table can possibly have?

796

---

What is a sub query? What are its various types?

826

---

Explain a data segment?

860

---

Can you have more than one content canvas view attached with a window ?

2081

---

Can we store images in oracle database?

764

---

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2820

---

How to view existing locks on the database?

800

---

What are the ways tablespaces can be managed and how do they differ?

1960

---