CREATE OR REPLACE TYPE
SQL>
SQL> SET ECHO ON
SQL>
SQL> CREATE OR REPLACE TYPE emp_chg AS OBJECT (
2 emp_id NUMBER,
3 pay_rate NUMBER(9,2),
4 pay_type CHAR(1),
5 leave_dept NUMBER,
6 join_dept NUMBER
7 );
8 /
SQL>
SQL> drop type emp_chg;
SQL>
SQL>
SQL> --
Related examples in the same category