Answer / kiran kumar

-- Is to reduce concurrency
1) share lock
---it allows the other users for only reading not to
insert or update or delete.
2) exclusive lock
--- only one user can have the privileges of insert
or update and delete of particular object
--- others can only read.
3) update lock
----multiple user can read, update delete
Lock levels :
1) table level 2) table space 3) data base level.

How to insert data into two tables using single control file?

3 Answers   Oracle, VTI,

---

can we write sql statement in Format trigger?

4 Answers  

---

what is global tempory table?

1 Answers   BirlaSoft,

---

While importing data into interface tables,if u got number of records are error(like more than 1000 records are error),how to imform user?

2 Answers  

---

how to enable Zoom function and steps?

1 Answers   Patni,

---

what is meant by anchoring?

3 Answers  

---

what is the use of format trigger?a

3 Answers  

---

What is the maximum number of statements that can be specified in a trigger statement?

1 Answers   Oracle,

---

why do we go for oracle apps technical other than sap and other packages?

2 Answers  

---

What are the files you have used in the part of Conversion and Interfaces?

2 Answers   Tech Mahindra,

---

types of invoices?

7 Answers   BelAir Store, Convergys, Wings Biotech,

---

Which is the best website to learn Oracle Apps?

2 Answers  

---