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!

PostCode constraint

user991291Feb 22 2009 — edited Feb 22 2009

Hi,

I am new to Oracle and am stuck with this Postcode constraint (validation)..... Below is my attempt, probably completely wrong:

alter table Student
add constraint postCode check LIKE (postcode, [A-Z|http://forums.oracle.com/forums/]{1,2}[0-9R|http://forums.oracle.com/forums/][0-9A-Z|http://forums.oracle.com/forums/]? [0-9|http://forums.oracle.com/forums/][A-Z-[CIKMOV]|http://forums.oracle.com/forums/]{2});

Could someone please help me with this... Any help would be appreciated!

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 22 2009

Added on Feb 22 2009

8 comments

2,088 views