oracle邮箱必须含有‘@’符号

电子邮箱要含有@符号check(字段 like ‘%@%’)

   create table stu(       
   
         s_ id number(10) primary key,       
         
         s_ email varchar2(10) check (s_email like '%@%') 
    );
    
    insert into stu values(1,'12@126.com');
   
    s_email like '%@%'