Hi All,
For Oracle reports, in a format trigger object I want to compare values from a query instead of hard coding it. Was wondering if there is a way to compare values returned by a query instead of hardcoding. Example below
if ((:g100prog = 'EXCL') or (:g100prog = 'INCL'))
then......
can we code it instead and compare with query returned values
if (:g100prog in (select distinct(value) from prog_type))
then ........
Please advise.