Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousand of experts, get answers to your questions and share knowledge with peers.
Hi, this is forms 11g.
I have to store an interval (hours and minutes) in database, and manage it from a form.
The db table is still undefined, so it doesnt have to be an actual interval oracle datatype. It could also be number(4,2), for example (99 hours length is more than enough).
How would yo do this? char control item with a format mask like 90":"00 and convert it to hours number in WVR and back in post-query?