Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Concurrency Problem, How to skip the loked records from my query

Re: Concurrency Problem, How to skip the loked records from my query

From: Jusung Yang <JusungYang_at_yahoo.com>
Date: 11 Apr 2003 14:26:04 -0700
Message-ID: <130ba93a.0304111326.6c5fccc4@posting.google.com>


What you are asking is not possbile.
Look up the NO WAIT option of the SELECT FOR UPDATE. But NO WAIT is based on the whole result set of the select statement, not any single record.

gsrnadeem_at_hotmail.com (Gaser Nadeem) wrote in message news:<7a7dd679.0304111031.7e99e8a6_at_posting.google.com>...
> Hi All,
>
> I have a Problem in the database concerning the locking record.
> I have an SQL Statement which result in one record and locking it,
> unfortunately this Statement must be run more than once at the same
> time.
> so i need a solution the ignore the locked recored and go to the
> next one .
>
> Ex.
> select emp_name
> from employee
> where Age > 60
> for update of emp_status;
>
> the table content is:
> name age .....
> . . .....
> . . .....
> Jone 61 .....
> Mike 62 .....
> Lura 61 .....
> . . .....
> . . .....
>
> so if I run this SQL st. for more than a time, the first run will
> result to JONE, but the second and third and fourth run will wait
> until the first one commit its transaction.
> I need a solution so that the second SQL will skip JONE record
> since it is locked and result to MIKE ... and so on ......
>
> thanks a lot for your help in advance ....
>
> best regards,
> gaser
Received on Fri Apr 11 2003 - 16:26:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US