PL/SQL
Parameterized views
Sometimes it would be easy to have a view which is parameterized. One of the options is to use sys_context. Another option is to makeuse of a pipelined function. Example package CREATE OR REPLACE PACKAGE okps_preop_tst IS TYPE outrec_typ IS RECORD ( id pof_dossiers.id%TYPE, dossier_type pof_dossiers.dsr_type%TYPE, dossier_nr pof_dossiers.dossier_nr%TYPE, dossier_datum pof_dossiers.dossier_datum%TYPE, Read more…