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.

SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me

6 Answers   TCS,

---

definition of cluster and non-clustered index?

0 Answers   CSS,

---

What are the different types of partitions in oracle?

0 Answers  

---

What does COMMIT do ?

4 Answers  

---

how the indexes are stored in the Oracle Database?

0 Answers  

---

---

Explain an exception?

0 Answers  

---

What are the roles of dba?

0 Answers  

---

What is a Data Segment ?

3 Answers  

---

What is enter substitution variable in oracle?

0 Answers  

---

select trunc(round(156.00,-1),-1) from dual;

2 Answers  

---

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

0 Answers  

---

If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 Answers  

---