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.

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,

---

Can We Restore a Table that accidantly dropped.

8 Answers   TCS,

---

What is the sql query to find the employee who has Nth maximum salary?

2 Answers  

---

wht r the base tables & primary key for BOM& WIP modules

1 Answers   Satyam,

---

What is the importance of batch source set up in ar? : oracle accounts receivable

0 Answers  

---

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

0 Answers  

---

What is the use of lockboxes? : oracle accounts receivable

0 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

0 Answers  

---

What is an Oracle database Full Backup?

0 Answers  

---

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,

---

hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent

1 Answers  

---

what is the querry to get first 10 records from the emp table?(emp no is the primary key)

4 Answers   Verizon,

---