Slide ‹#› of 37
Universal Value List (3)
u
Test SQL statement with the following code:
u
u
select
id_nr, display_tx
u
from table
(
u
cast
(
f_getLov_nt
u
(:1, -- 'emp'
u
:2, -- 'empno'
u
:3, --'ename||''-
''||job'
u
:4
-- 'ename‘
)
u
as lov_nt
)
u
)