PL/SQL - How do you set table for read only access ?

GeekInterview.com > Interview Questions > Oracle > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 168 of 241

How do you set table for read only access ?

if i am updating one record in a table at that time no other user can't able insert ,update the record in same table How is it possible

Total Answers and Comments: 4

Last Update: July 23, 2008 Asked by: nitin_kumat

Sponsored Links

Best Rated Answer

—

Submitted by: sippsin

you can select the table for updation

for eg: select * from emp for update;

no you can do the update/insert anything you want...

any other user or session would be able to do any insert/update to the same table only after you release the table by commit or rollback.....

Above answer was rated as good by the following members:
ds_devi

March 25, 2007 23:36:23

ily_saravanan

Member Since: October 2006 Contribution: 16

RE: How do you set table for read only access ?

If you update or delete the records in the table at the same time no body can update or delete the same records which you updated or deleted because oracle lock the data which u updated or deleted.

Is this answer useful? Yes | No

April 20, 2007 08:59:17

sandeep katta

RE: How do you set table for read only access ?

You can use view for this purpose because you can set view as read only.

Is this answer useful? Yes | No

May 03, 2008 06:12:23

krishnaindia2007

Member Since: September 2007 Contribution: 854

RE: How do you set table for read only access ?

If a transaction is updating data in a database it gets an exclusive lock on that part of the database. No other transaction can read or change this data.

Is this answer useful? Yes | No

July 22, 2008 23:38:41

sippsin

Member Since: June 2006 Contribution: 6

RE: How do you set table for read only access ?

you can select the table for updation

for eg: select * from emp for update;

no you can do the update/insert anything you want...

any other user or session would be able to do any insert/update to the same table only after you release the table by commit or rollback.....

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank