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.

which one is currently in used software cmpanies.

0 Answers  

---

What is auto invoicing? Explain : oracle accounts receivable

0 Answers  

---

What is the difference between recovery and restoring of the oracle database?

0 Answers  

---

QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

0 Answers   Telesis,

---

How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views

2 Answers   Cap Gemini, Syntel,

---

what is difference between inner join & nested query or subqueries

0 Answers  

---

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

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,

---

Can we modify approve purchase order?if yes what is navigation?

0 Answers   L&T,

---

what is shared memory?

1 Answers   IBM,

---

Explain an ORA-01555

2 Answers  

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

1 Answers   HCL,

---