30
Query the Function as a Table
uGeneric 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           )