Interested to Buy Any Domain ? << Click Here >> for more details...
what is sql*loader parameters and where we will use it.
- 1 Answers
- 7452 Views
- Accenture, I also Faced
- E-Mail Answers
Answer / 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 |
pl help me, i want oracle HRMS training institute address,in chennai
what is correlated subquery
what is the querry to get first 10 records from the emp table?(emp no is the primary key)
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
For web applications from which version of Oracle is suitable?
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
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.
What are different types of transactions in ar? : oracle accounts receivable
Explain prerequisites and post activities of oracle database installation
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
Oracle General 
