what is sql*loader parameters and where we will use it.
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 |
What are different types of transactions in ar? : oracle accounts receivable
How do you switch from an init.ora file to a spfile?
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.
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is the difference between conversions and interfaces? : oracle accounts receivable
What type of index should you use on a fact table?
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
What is database schema?
What is Virtual Memory?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
0 Answers Pathway Technologies,
i have marks in table,how to find total?
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure