3 Replies Latest reply: May 1, 2013 12:32 PM by CraigB RSS

    interval day to second in oracle forms 6i

    kaminanikamini
      hello
      i am using oracle forms 6i on windows 7
      Database:oracle database 10g
      i want to store the data of workers free time in hours and minutes.
      So i have created my table structure as

      WID NUMBER(10)
      EMPID NUMBER(7)
      BIG_PCS NUMBER(10)
      BIG_PCS_WEIGHT NUMBER(5,2)
      SMALL_PCS NUMBER(10)
      SMALL_PCS_WEIGHT NUMBER(5,2)
      FREE_TIME             INTERVAL DAY(6) TO SECOND(6)
      REMARK VARCHAR2(500)
      DEPTID NUMBER
      PROCESS_ID NUMBER
      WORK_DATE DATE


      But forms does not accept this data type.

      Thanks.

      Edited by: kaminanikamini on Apr 30, 2013 1:50 AM