I have a date Picker item... I want default date to be based on the max value from a table...
something like this:
select max(date) dt from table_a
please advice how to do it?
put following equation in default value of item
select max(date) dt into :PXX_ITEM
and select default value type as PL/SQL FUNCTION BODY