Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Programming

 

Delete employee with stored procedure

SQL> SQL> CREATE TABLE emp   2     (id         VARCHAR2(10) NOT NULL,   3      course     VARCHAR2(10),   4      year       VARCHAR2(4),   5      PRIMARY KEY (id)); Table created. SQL> SQL> CREATE OR REPLACE PROCEDURE Delete_emp(delete_id emp.id%TYPE) AS   2   3  BEGIN   4     DELETE FROM emp   5     WHERE id = delete_id;   6  END Delete_emp;   7  / Procedure created. SQL> drop table emp; Table dropped.