CREATE PROCEDURE incluir_segmercado
(p_ID in number, p_DESCRICAO in varchar2) ;
IS
BEGIN
INSERT INTO SEGMERCADO (ID, DESCRICAO) VALUES (p_ID, UPPER(p_DESCRICAO));
COMMIT;
END;
EXECUTE incluir_segmercado(4, 'Farmaceuticos');
1 VAREJISTA 3 ATACADISTA 2 INDUSTRIAL 4 FARMACEUTICOS
