econz icon

Firebird - Expressões Regulares

econz | PRO | 10/01/20 04:40:35 PM UTC | 0 ⭐ | 8469 👁️ | Never ⏰ | []
PL/SQL |

290 B

|

None

|

0 👍

/

0 👎

CREATE domain D_TP_CEP AS VARCHAR(10) character SET UTF8
   CHECK (TRIM(trailing FROM VALUE) similar TO '[0-9][0-9][0-9][0-9][0-9][-][0-9][0-9][0-9]');
 
CREATE domain D_TP_EMAIL AS VARCHAR(200) character SET UTF8
   CHECK (TRIM(trailing FROM VALUE) similar TO '[a-z]+@{1}[a-z]+.{1}[a-z]+');
 

Comments

  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    👍

    /

    👎

    
        
  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    👍

    /

    👎