Interested to Buy Any Domain ? << Click Here >> for more details...
what is sql*loader parameters and where we will use it.
- 1 Answers
- 7320 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
What is the sql query to find the employee who has Nth maximum salary?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
What is the importance of batch source set up in ar? : oracle accounts receivable
Are These Dff's Flexible?
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
i want to know about the javaBean.what is its purpose and how it can use in Forms.
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.
default triggers available for reports
where the dff data will be stored
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
3. Steps in UAT?
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
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 an Oracle database Full Backup?
