SQL> CREATE OR REPLACE TYPE overtime_type 
  2  AS OBJECT (
  3      ot_type     VARCHAR2(10)
  4  ,   ot_hours    NUMBER
  5  )
  6  /
  
Type created.
  
SQL> CREATE TABLE timesheet (
  2      empno       NUMBER
  3  ,   d           DATE
  4  ,   overtime    overtime_type
  5  )
  6  /
  
Table created.
  
SQL> DECLARE
  2      l_overtime          overtime_type;
  3  BEGIN
  4      l_overtime := overtime_type('A',2.5);
  5      INSERT INTO timesheet (
  6          empno
  7      ,   d
  8      ,   overtime
  9      ) VALUES (
 10          1234
 11      ,   TO_DATE('20031103','YYYYMMDD')
 12      ,   l_overtime
 13      );
 14      l_overtime := overtime_type('B',1);    
 15      INSERT INTO timesheet (
 16          empno
 17      ,   d
 18      ,   overtime
 19      ) VALUES (
 20          5678
 21      ,   TO_DATE('20031103','YYYYMMDD')
 22      ,   l_overtime
 23      );
 24      COMMIT;
 25  END;
 26  /
  
PL/SQL procedure successfully completed.
  
SQL> SELECT t.empno
  2  ,      TO_CHAR(t.d
  3         ,       'fmMM/DD/YYYY') work_date
  4  ,      t.overtime.ot_type
  5  ,      t.overtime.ot_hours
  6  FROM   timesheet     t
  7  WHERE  t.overtime.ot_hours > 2
  8  /
  
     EMPNO WORK_DATE  OVERTIME.O OVERTIME.OT_HOURS
---------- ---------- ---------- -----------------
      1234 11/3/2003  A                        2.5
  
SQL>