Dear All,
I need to create a table with field condition like phone number must start with '0' and email address must have the letter '@'. I am new so can anyone tell me how.
So ###### I am stuck in email and phone as don`t know how to proceed. Condition are:
Phone Number must start with 0
Email should have @ string
My code:
create table if not exists CUSTOMER( Cust_firstame varchar2(40) not null, Cust_sirname varchar2(40) not null, Cust_house number not null default '0', Cust_addr varchar2(100), Cust_town varchar2(100), Cust_town varchar2(100), Cust_state varchar2(100), Cust_pcode varchar2(8) not null, Cust_phone varchar2(14), Cust_email varchar2(30),
Anyone can help.
Also is it possible to add comment like Cust_house showing comment "House Number"
Thank you