Advanced Datatype Example 2b
uCompletely generic value list query for any UI
ØUses bind variables – no significant performance impact
ØCompletely dynamic – any new fields/tables/etc.
u
uselect id_nr, display_tx
ufrom table(
u           cast(f_getLov_nt
u                  ('emp',
u                   'empno',
u                   'ename||''-''||job',
u                   'ename')
u           as lov_nt)
u           )