Answer / swetha

1) sql*loader is used only to load data into database
tables from external files.
It's all about data loading.


2) Import is used to read and write the operating system
files in and out of database.
it's completely a different aspect.

We can deal with structures as well as data here.
We can import entire database or a particular user/schema
or required table spaces with structures or even with data
according to the requirement.

How would you go about generating an EXPLAIN plan?

1 Answers   Satyam,

---

How would you determine who has added a row to a table?

0 Answers  

---

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

0 Answers   Wipro,

---

how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.

1 Answers   Alshaya,

---

Is there any link between pr form(purchse requisition)and po form(purchase order)

0 Answers   L&T,

---

What background process refreshes materialized views?

1 Answers  

---

how to write customizations in po

0 Answers   Ernst Young,

---

what is different between inline query,subquery& corelated query?

8 Answers   Quest,

---

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  

---

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

0 Answers   TCS,

---

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

0 Answers  

---

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

0 Answers  

---