SQL>
SQL> create or replace type employeeType is object (
2 empNo NUMBER,
3 eName VARCHAR2(10),
4 job VARCHAR2(9),
5 mgr NUMBER,
6 hireDate DATE,
7 sal NUMBER,
8 comm NUMBER,
9 deptNo NUMBER
10 )
11 /
Type created.
SQL> declare
2 v_employeeType employeeType;
3 begin
4 --v_employeeType.sal:=500; -- ILLEGAL
5 NULL;
6 end;
7 /
PL/SQL procedure successfully completed.
SQL>
SQL> drop type employeeType;
Type dropped.
SQL>
SQL>
|