Forum Stats

  • 3,874,171 Users
  • 2,266,675 Discussions
  • 7,911,750 Comments

Discussions

Oracle Reports 12c

user5108636
user5108636 Member Posts: 1,763 Silver Badge

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.