Skip to Main Content

APEX

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!

Checking that a record already Exists

SteveWelchAug 10 2011 — edited Aug 16 2011
Hello,

I would like to create a validation to check if a record has already been created. I'm not sure how to go about it.

The record has a name, date_from and date_to. If I were to create another record for an existing user and one of the dates fell within a range of dates already existing for that user I would like to be able to notified.

Does anyone know how to handle this validation?


Kind Regards,

Steve Welch
This post has been answered by Kiran Pawar on Aug 16 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 13 2011
Added on Aug 10 2011
22 comments
3,287 views