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.

Explain constraining triggers.

1093

---

How do you store pictures in a database?

1003

---

How to define a variable to match a table column data type?

988

---

How can you use check constraints for self referential integrity?

969

---

What is redo log?

1064

---

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2555

---

What is a nested table and how is it different from a normal table?

1049

---

What is difference between sid and service name in oracle?

956

---

What is an oracle recycle bin?

1009

---

How to create a testing table in oracle?

988

---

How to list all indexes in your schema?

1093

---

How to use in conditions in oracle?

1058

---

What happens if recursive calls get out of control?

1082

---

What are the various types of snapshots ?

1027

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

994

---