Delete employee with stored procedure : Delete « PL SQL Programming « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Programming
3. Delete

SQL>
SQL>
SQL>
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.