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.

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

0 Answers  

---

What is the data type of dual table?

0 Answers  

---

I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????

1 Answers  

---

What is the max number of columns in an oracle table?

0 Answers  

---

How to use "if" statements on multiple conditions?

0 Answers  

---

Can we create more than one constraint to column ?

6 Answers  

---

interview questions with answer for cts

0 Answers   Cognizant,

---

How do I start tns listener?

0 Answers  

---

if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.

1 Answers   MasterCard,

---

What is truncate oracle?

0 Answers  

---

How to delete a column in an existing table in oracle?

0 Answers  

---

How to select some rows from a table in oracle?

0 Answers  

---