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.

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

2038

---

Explain the use of consistent option in exp command.

1139

---

Can the query output be sorted by multiple columns in oracle?

1052

---

How to declare a local variable?

1171

---

List the various oracle database objects?

1108

---

How can I see all tables in oracle?

1060

---

Is it possible to insert comments into sql statements return in the data model editor ?

2636

---

What is ordinary table in oracle?

1238

---

Why is oracle used?

978

---

Why does oracle 9i treat an empty string as null?

1126

---

How to run create database statement?

1075

---

How to create a new table in oracle?

1231

---

Explain integrity constraint?

1207

---

how to clone 9i Database on to 10g Database.

2383

---

How to create an oracle testing table?

1126

---