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!

If Null then do not insert

474835Jan 23 2006 — edited Jan 23 2006

Hi All,

I am writing a function in which I am selecting 7 fields from the join of two tables.
I want to ensure that if no row is returned then the logic should not insert the rows into another table.

Can anyone tell how do I check for no rows returned?

Had it been a single field I could have used NVL , but how for multiple fields?

Regards,
Amit

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2006

Added on Jan 23 2006

10 comments

951 views