How can one skip any number of rows while loading the DB
tables with SQL Loader? Similarly how can one skip any
column?
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.
Is This Answer Correct ? | 0 Yes | 0 No |
How to retrieve the count of updated rows?
Explain the use of ignore option in imp command.
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to use "in" parameter properly?
Which Oracle App Is Most Popular One ?
where we have to use ON clause and where we have to use USING clause in JOINS
what r tyhe major differences between oracle 9i & 10g?
What is an Index ?
What are the different types of record groups in oracle? Explain each of them
Why does for update in oracle 8 cause an ora-01002 error?
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
How to shutdown your 10g xe server?