Select * from Table Name for update
Hi
I would like to know that from oracle coding best practices how does "select * from <table name> for update" compares to "update <table name> set <col name> = <value>"
why would someone use "select * from <table Name> for update" ? Is this possible that this can cause database locking? Is there a better alternate for this update statement?
thanks
I would like to know that from oracle coding best practices how does "select * from <table name> for update" compares to "update <table name> set <col name> = <value>"
why would someone use "select * from <table Name> for update" ? Is this possible that this can cause database locking? Is there a better alternate for this update statement?
thanks
0