ex_blocplsql

DECLARE
          Comp_id NUMBER;
          Comp_name CHAR(20) := 'ACME SHOWERS';
BEGIN
           SELECT company_id_seq.NEXTVAL INTO comp_id
           FROM dual;

INSERT INTO company (company_id, company_name)
VALUES (comp_id, comp_name);
END;