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 you store pictures in a database?

963

---

Explain the difference between sap and oracle?

984

---

What is define in oracle?

1016

---

How do you bind variables in oracle?

936

---

What is difference between sid and service name in oracle?

914

---

Compare and contrast between sql and sql server and explain its various functions?

927

---

1) Does oracle have any table which contain all the exceptions and it's code internally?

1712

---

What is a synonym? What are its various types?

1052

---

How to use attributes of the implicit cursor in oracle?

961

---

What is the disadvantage of User defind function?

2250

---

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5345

---

What is a data dictionary and how can it be created?

1072

---

Explain the use of compress option in exp command.

972

---

What is PL/SQL ?

1924

---

What is dual table oracle?

932

---