Interested to Buy Any Domain ? << Click Here >> for more details...
what is sql*loader parameters and where we will use it.
- 1 Answers
- 7346 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
Are These Dff's Flexible?
What is the difference between oracle media recovery and crash recovery?
difference of using cursor for loop and open,fetch,close.which one is better
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
what is the link between suppliers and banks in ap module in oracle apps? And also query?
how to write customizations in po
What do you mean by Oracle MEDIA RECOVERY?
What view would you use to determine free space in a tablespace?
default triggers available for reports
What is db_recovery_file_dest in oracle? When do you need to set this value?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
What is the disk migration? what is the steps involved in oracle disk migration?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
A scenario for amount correction & how to use amount correction functionality in AP invoices
