Hi
I am building an online booking system - think ticketmaster.
What I am trying to do is when a user selects a time from a select list, if the time slot for that date has already been booked then that time slot i.e. 2-3pm will be greyed out in the list
This is the LOV that populated the select list
select to_char(trunc(sysdate)+((i-1)/48),v('APP_TIME_FORMAT')) d,
to_char(trunc(sysdate)+((i-1)/48),v('APP_TIME_FORMAT')) r
from wwv_flow_dual100
where i < 49
order by i
and this is the computation before header
select to_char(trunc(to_date(to_char(current_timestamp,'&APP_TIME_FORMAT.'),'&APP_TIME_FORMAT.'),'HH')+1/24,'&APP_TIME_FORMAT.') from dual