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…