This discussion is archived
3 Replies Latest reply: May 1, 2013 10:32 AM by CraigB RSS

interval day to second in oracle forms 6i

kaminanikamini Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points