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 concurrency in oracle?

0 Answers  

---

What is Hash Index?

1 Answers  

---

How to write an inner join with the where clause in oracle?

0 Answers  

---

What are the different type of Segments ?

2 Answers  

---

What are the tools for Oracle ?

0 Answers   Infosys,

---

What are the different pseudo commands? Explain in general?

0 Answers  

---

Give syntax for SQL and ORACLE joins.

0 Answers   TCS,

---

What are the types of trigger in oracle?

0 Answers  

---

10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.

3 Answers   Wipro,

---

Is oracle a language?

0 Answers  

---

How to do a full database export?

0 Answers  

---

20. Using a set operator, display the client number of all clients who have never placed an order.

0 Answers   Wipro,

---