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 are the components of physical database structure in the Oracle database?

1 Answers  

---

Can we insert data in view oracle?

0 Answers  

---

How to select an oracle system id (sid)?

0 Answers  

---

What is a sub query? Describe its types?

0 Answers  

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

0 Answers   CTS,

---

What is the difference between postgresql and oracle?

0 Answers  

---

select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help

6 Answers  

---

What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

2 Answers  

---

How to turn on or off recycle bin for the session?

0 Answers  

---

What is a read write transaction in oracle?

0 Answers  

---

Why do you create or replace procedures rather that drop and recreate.

0 Answers  

---

What is the difference between view and materialized view in Oracle?

0 Answers   MCN Solutions,

---