Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Implicit Cursor FOR LOOP And WHERE CURRENT OF

CeritoApr 2 2014 — edited Apr 2 2014

Is it possible to add FOR UPDATE and WHERE CURRENT OF to an implicit cusror FOR LOOP?  There appears to be no way to reference the cursor as one can with an explicit cursor.

BEGIN

  FOR item IN (

  SELECT last_name, job_id

  FROM employees

  WHERE job_id LIKE '%CLERK%'

  AND manager_id > 120

  ORDER BY last_name

  )

  LOOP

     ...

     ...

     ...

  END LOOP;

END;

/

Thanks

This post has been answered by Galo Balda on Apr 2 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 30 2014
Added on Apr 2 2014
7 comments
5,039 views