现在有一张员工信息表empemp表有以下字段idnameagesexcity 帮我用oracle中的存储过程实现对该表的增删改查操作其中id是序列自增你需要帮我生成一个自增序列

生成序列的语句：

CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1;

增加员工信息的存储过程：

CREATE OR REPLACE PROCEDURE add_emp ( p_name IN VARCHAR2, p_age IN NUMBER, p_sex IN VARCHAR2, p_city IN VARCHAR2 ) AS BEGIN INSERT INTO emp (id, name, age, sex, city) VALUES (emp_seq.NEXTVAL, p_name, p_age, p_sex, p_city); END;

删除员工信息的存储过程：

CREATE OR REPLACE PROCEDURE delete_emp (p_id IN NUMBER) AS BEGIN DELETE FROM emp WHERE id = p_id; END;

修改员工信息的存储过程：

CREATE OR REPLACE PROCEDURE update_emp ( p_id IN NUMBER, p_name IN VARCHAR2, p_age IN NUMBER, p_sex IN VARCHAR2, p_city IN VARCHAR2 ) AS BEGIN UPDATE emp SET name = p_name, age = p_age, sex = p_sex, city = p_city WHERE id = p_id; END;

查询员工信息的存储过程：

CREATE OR REPLACE PROCEDURE get_emp (p_id IN NUMBER) AS v_name emp.name%TYPE; v_age emp.age%TYPE; v_sex emp.sex%TYPE; v_city emp.city%TYPE; BEGIN SELECT name, age, sex, city INTO v_name, v_age, v_sex, v_city FROM emp WHERE id = p_id;

DBMS_OUTPUT.PUT_LINE('Name: ' || v_name);
DBMS_OUTPUT.PUT_LINE('Age: ' || v_age);
DBMS_OUTPUT.PUT_LINE('Sex: ' || v_sex);
DBMS_OUTPUT.PUT_LINE('City: ' || v_city);

END