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.

How to find out what oracle odbc drivers are installed?

0 Answers  

---

How to view the dropped tables in your recycle bin?

1 Answers  

---

What is the sql query to concatenate column values from multiple rows in oracle?

0 Answers  

---

what are the advantages of running a database in NO archive log mode?

1 Answers  

---

How many types of cluster table in Oracle?

0 Answers   MCN Solutions,

---

What is background process in Oracle?

0 Answers   MCN Solutions,

---

How can I introduce multiple conditions in like operator?

0 Answers  

---

what are the different types of cursors? explain?

4 Answers  

---

Explain coalesce function?

0 Answers  

---

I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?

2 Answers   Philips,

---

How many memory layers are in the shared pool?

1 Answers  

---

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1 Answers  

---