39 of 62
Nested Tables - Example 2d
uCreate a VIEW on the top of the SQL statement.
ØCompletely hides the underlying logic from the UI
ØINSTEAD-OF triggers make logic bi-directional
ØMinor problem: There is still no way of passing
parameters into the view other
than some kind of global.
Create or replace view v_generic_lov as
select id_nr, display_tx
from table( cast(f_getLov_nt
(GV_pkg.f_getCurTable,
GV_pkg.f_getPK(GV_pkg.f_getCurTable),
GV_pkg.f_getDSP(GV_pkg.f_getCurTable),
GV_pkg.f_getSORT(GV_pkg.f_getCurTable))
as lov_nt)
)