what is sql*loader parameters and where we will use it.
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
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
What is db_recovery_file_dest in oracle? When do you need to set this value?
default triggers available for reports
which one is currently in used software cmpanies.
8. Supporting AP, AR and GL?
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
How would you determine what sessions are connected and what resources they are waiting for?
Explain about party and customer in ar : oracle accounts receivable
Is there any link between pr form(purchse requisition)and po form(purchase order)
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
Explain the use of table functions.