Mega Code Archive

 

Categories / Oracle PLSQL / Object Oriented Database

 

Type with member 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> CREATE OR REPLACE TYPE empType AS OBJECT   2     (id                     VARCHAR2(10),   3      course                 VARCHAR2(20),   4      year                   VARCHAR2(4),   5      MEMBER PROCEDURE       Delete_emp )   6  / Type created. SQL> SQL> CREATE OR REPLACE TYPE BODY empType AS   2     MEMBER PROCEDURE   3     Delete_emp IS   4     BEGIN   5           DELETE FROM emp   6           WHERE emp.id = self.id;   7     END Delete_emp;   8  END;   9  / Type body created. SQL> drop table emp; Table dropped.