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 do I manually uninstall oracle client?

1079

---

How to create additional tablespaces for an new database?

1019

---

what is the dual table in oracle?

987

---

Please explain compound trigger in oracle?

1051

---

Explain the use of analyse option in exp command.

1122

---

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1774

---

How to export your connection information to a file?

1121

---

Differentiate between function and procedure in oracle.

1069

---

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

1042

---

What is the Tune Query

2286

---

What are the differences between blob and clob in oracle?

1080

---

How to list all user accounts in oracle?

1021

---

Is oracle an operator?

921

---

Can we store pictures in the database and if so, how it can be done?

1026

---

What is dynamic proxy?

999

---