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

How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun

8 Answers  

---

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

0 Answers   HP,

---

What are the mandatory setups in setting up a PO in oracle

1 Answers   Silicon,

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

0 Answers  

---

What is the difference between oracle media recovery and crash recovery?

0 Answers  

---

WHAT IS CARTESIAN PRODUCT?

2 Answers  

---

what is domain in database and its benefits?

0 Answers  

---

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?

0 Answers   Cap Gemini,

---

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

1 Answers  

---

When the procedures or packagess become invalidate

3 Answers   TCS,

---

Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....

2 Answers   Ion Exchange,

---

Give the two types of tables involved in producing a star schema and the type of data they hold.

1 Answers  

---