Interested to Buy Any Domain ? << Click Here >> for more details...
what is sql*loader parameters and where we will use it.
- 1 Answers
- 7336 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / arijitnit
sql*loader is a bulk importing tool to import data tables
present in various formats like CSV.
We have to define a control file and in it we have to give
some commands.
LOAD DATA
INFILE *(this assumes data is in the same ctl file)
INTO TABLE TABLE_NAME(COLUMNS)
FIELDS TERMINATED BY ;
BEGIN DATA
...DATA IN CSV FORMAT
now in command prompt type sqlldr USERID=scott/tiger
CONTROL=test.ctl
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
A scenario for amount correction & how to use amount correction functionality in AP invoices
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
what is semphore explian it?
types of receipts and detail desription about recipts and tables effected by receipts?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
What is the disk migration? what is the steps involved in oracle disk migration?
what is difference between inner join & nested query or subqueries
How to clone the database using RMAN back
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
