SQL>
SQL> CREATE Or Replace TYPE EmployeeType AS OBJECT (
2 id NUMBER,
3 name VARCHAR2(15),
4 description VARCHAR2(22),
5 salary NUMBER(5, 2),
6
7 MEMBER FUNCTION getByDate RETURN DATE
8 );
9 /
Type created.
SQL> desc EmployeeType;
Name Null? Type
ID NUMBER
NAME VARCHAR2(15)
DESCRIPTION VARCHAR2(22)
SALARY NUMBER(5,2)
METHOD
------
MEMBER FUNCTION GETBYDATE RETURNS DATE
SQL> /
Type created.
SQL>