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!

Cursor ROWTYPE and individual fields

user5108636Nov 20 2017 — edited Nov 21 2017

Hi All,

Using ORacle 12c database. With PLSQL, I have defined a cursor 'c_emp' is select * from employees. I have two variables one ROWTYPE for the employee record and another an emp_id declared in the PLSQL block.

I do a fetch on the cursor into ROWTYPE variable. My question is how do I populate the emp_id variable using the cursor.

Please advise, any example will be nice.

Thanks

This post has been answered by user5108636 on Nov 21 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 19 2017

Added on Nov 20 2017

9 comments

520 views