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 API and Interface?

2 Answers   Infogain,

---

Form development process?

1 Answers  

---

what are the error tables in OM

2 Answers   Fujitsu,

---

how can i print random rows in plsql table

0 Answers   Fujitsu, KPIT,

---

What is sca and how is it useful?

0 Answers  

---

what are the default arguments for pl/sql program?

1 Answers  

---

while doing the process of conversion if got any data error out what is the next step to reprocess

1 Answers  

---

What is REF Cursor?

19 Answers   Infosys, Intelligroup,

---

any one can expalin report registration steps?

6 Answers   Infosys,

---

Except the SRS window in which we can submit the concurrent program.

5 Answers   IBM, TCS,

---

1) why we need to do Validations when the Standard Conc. Prog or the API will do all the validations 2) How can we display more then 1 column data in a formula column (Ex displaying Empno, Ename, sal data in one Formula column) 3) is it possible to give 2 out paramaters in a function

2 Answers   Zensar,

---

Write an SQL Query to Delete Duplicate records from a table using ROWID.

24 Answers   pspl, Satyam, Thinkways,

---