Oracle Database Discussions

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!

Date range validation

144315Jul 25 2007 — edited Jul 25 2007

Hi,

Is there any way I could make sure users never type in dates outside a predetermined range for all the date columns without having to implement triggers for each date column individually. Isn't there any parameter I can set somewhere to tell Oracle not to accept dates outside a specific range in all my existing and future applications.

So, if a user accidentally typed '12-MAR-206' instead of '12-MAR-2006', he would have an error message.

Thanks,
Denis.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 22 2007

Added on Jul 25 2007

#general-database-discussions

7 comments

774 views