what is sql*loader parameters and where we will use it.
- 1 Answers
- 6183 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
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
as a technical developer in oracle applications which type errors feced in your experience sofar
What is auto invoicing? Explain : oracle accounts receivable
Is there any link between pr form(purchse requisition)and po form(purchase order)
How to clone the database using RMAN back
how to replace not in with not exist?
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What is Tax Categories?
what are the API of GL,PO,AP
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
