Advertisement
econz

Firebird - Expressões Regulares

Oct 1st, 2020
1,092
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.29 KB | None | 0 0
  1. CREATE domain D_TP_CEP AS VARCHAR(10) character SET UTF8
  2.    CHECK (TRIM(trailing FROM VALUE) similar TO '[0-9][0-9][0-9][0-9][0-9][-][0-9][0-9][0-9]');
  3.  
  4. CREATE domain D_TP_EMAIL AS VARCHAR(200) character SET UTF8
  5.    CHECK (TRIM(trailing FROM VALUE) similar TO '[a-z]+@{1}[a-z]+.{1}[a-z]+');
  6.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement