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.

what is difference between po_headers_all and po_headers

2 Answers   NTT Data,

---

why r u move in the cus_top only why not move another top

4 Answers   Wipro,

---

In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?

2 Answers  

---

why r u move in the cus_top only why not move another top

4 Answers  

---

Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?

7 Answers   Satyam,

---

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

5 Answers   Wipro,

---

How to create multi-layout reports ? If we have 5 layouts , then how to get into the 4th one ?

3 Answers   IBM,

---

Name the different Cursor Attributes.

2 Answers   Satyam,

---

How relation will be made between modules in oracle financial?

4 Answers   HCL, Wipro,

---

How to know the number of invoices generated for one PO from front end (navigation)?

1 Answers   Oracle,

---

In support project one ticket alloted which steps follows manualy tell me ?

0 Answers   BEL, Questam,

---

in one report using two layout models.if yes how to do

2 Answers  

---