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!

How to create a condition cursor

deahayesOct 10 2022

Hello all,

Need help creating cursors. I'm sure a loop is needed not sure how. I have a staging table where if column action flag = A, insert record into history table, if Action flag= U, update the history table record. How do I call the staging table to check if record has to be inserted/updated to history table?

This post has been answered by BluShadow on Oct 11 2022
Jump to Answer
Comments
Post Details
Added on Oct 10 2022
6 comments
557 views