Copiar em Aula

ALTER TABLE pastebin."USER"
    ADD CONSTRAINT nome_maior_4 CHECK (LENGTH(nome) >= 4),
    ADD CONSTRAINT email_maior_10 check (LENGTH(email) >= 10),
    ADD CONSTRAINT password_has_needed_chars CHECK (
        (LENGTH(passwd) - LENGTH(REGEXP_REPLACE(passwd, '[A-Z]', '', 'g'))) >= 2 AND
        (LENGTH(passwd) - LENGTH(REGEXP_REPLACE(passwd, '[a-z]', '', 'g'))) >= 4 AND
        (LENGTH(passwd) - LENGTH(REGEXP_REPLACE(passwd, '[0-9]', '', 'g'))) >= 3 AND
        (LENGTH(passwd) - LENGTH(REGEXP_REPLACE(passwd, '[!"#$%\/()"=?»«~^\\\.-_:.;,]', '', 'g'))) >= 2
    )
;