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.

How to call a stored function with parameters?

0 Answers  

---

i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings

2 Answers  

---

How many categories of data types?

0 Answers  

---

How to invoke the original export import utilities?

0 Answers  

---

What to do if the startbd.bat failed to start the xe instance?

0 Answers  

---

what is the use of ondelete cascade?

3 Answers  

---

How to delete a column in an existing table?

0 Answers  

---

How can I combine multiple rows into a comma-delimited list in oracle?

0 Answers  

---

find out the third highest salary?

92 Answers   CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,

---

select * from emp what happened internally when we write this query in the sql prompt?

5 Answers  

---

How do I manually create a database in oracle?

0 Answers  

---

What is Virtual Private Database in Oracle?

0 Answers   MCN Solutions,

---