LOCKS?
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
How to insert data into two tables using single control file?
can we write sql statement in Format trigger?
what is global tempory table?
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?
how to enable Zoom function and steps?
what is meant by anchoring?
what is the use of format trigger?a
What is the maximum number of statements that can be specified in a trigger statement?
why do we go for oracle apps technical other than sap and other packages?
What are the files you have used in the part of Conversion and Interfaces?
types of invoices?
7 Answers BelAir Store, Convergys, Wings Biotech,
Which is the best website to learn Oracle Apps?