Interested to Buy Any Domain ? << Click Here >> for more details...
How can one skip any number of rows while loading the DB
tables with SQL Loader? Similarly how can one skip any
column?
- 1 Answers
- 3653 Views
- IBM, I also Faced
- E-Mail Answers
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 |
What types of joins are used in writing subqueries?
What are the commands youd issue to show the explain plan for select
How to create an initialization parameter file?
What is meant by recursive hints ?
Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?
What is a cluster?
How to increment dates by 1 in oracle?
what is the use of ondelete cascade?
How many types of tables are there in oracle?
What are dml statements in oracle?
How many file formats are supported to export data?
What is meant by an index?
Oracle General 
