CREATE TABLE acoes (
    id     bigint NOT NULL,
    nome   VARCHAR2(100) NOT NULL,
    metodo VARCHAR2(10) NOT NULL
);

ALTER TABLE acoes
    ADD CHECK ( metodo IN ( 'DELETE', 'GET', 'PATCH', 'POST', 'PUT' ) );