Skip to Main Content
Forums

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!

CHECK Constraint to Check Date column is Monday or not

1001979Apr 9 2013 — edited Apr 9 2013
Hi,

I have already one table with unique constraint with column START_DATE, END_DATE etc. Now I need to add CHECK constraint to START_DATE and END_DATE columns. CHECK should contains inserting value should be Monday only for START_DATE and Sunday only for END_DATE.

Please provide me ALTER statement or any function which can handle this scenario.

Thanks.....
This post has been answered by Nimish Garg on Apr 9 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2013
Added on Apr 9 2013
3 comments
900 views