econz

Firebird - Expressões Regulares

Oct 1st, 2020
598
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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.  
RAW Paste Data