|
-
Interesting problem.
Extremely odd requirement, but and interesting problem. 
I'm not sure you can do this in straight SQL. I'll keep pondering on it, however.
For PL/SQL, you could use the BULK cursor operations to collect the 60 records you want to update, then use the FORALL to update them all in one shot. That would be the next-fastest thing to a single SQL statement.
- Chris
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|