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!

Conditional based inserts

A3006Aug 28 2025

Hello experts,

So recently I was asked in an interview, how can we insert data into tables based on the value we have bulk collected.

I have shared the structure as an image.

Expectation was to complete the block to have exceptions saved, if possible can we use for all to do such condition based insert. If not how else.

Comments
Post Details
Added on Aug 28 2025
9 comments
257 views