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.