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

968167Jan 27 2013 — edited Jan 29 2013
Hello guys,

I got few questions regarding the check condition.

I am creating a table and one of the columns is for student code, which is 3 letters uppercase and 3 numbers.
How to check if these conditions are met ?

Also I need a column POSTCODE where function checks if the post code is in the correct format, how to do it ?


thanks in advance

Edited by: 965164 on Jan 27, 2013 3:08 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2013
Added on Jan 27 2013
12 comments
4,275 views