what is sql*loader parameters and where we will use it.
- 1 Answers
- 6198 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 |
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
What is Virtual Memory?
how can we send a concurrent program output to the clients through mail or fax give me example.
Compare and contrast TRUNCATE and DELETE for a table.
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.
How do you create a credit note against an invoice? : oracle accounts receivable
What is supporting issues GL AP and AR?
How client makes connection with server in client/server architecture?
3. Steps in UAT?
default triggers available for reports
Explain the process of recievables in oracle financials. : oracle accounts receivable
how to replace not in with not exist?
Oracle General 
