Search the Community
Showing results for tags 'SQL Comment'.
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 varch