Oracle Parameterized Views скачать в хорошем качестве

Oracle Parameterized Views

Learn how to implement Parameterized Views in Oracle! 00:00 Intro 00:13 Oracle Parameterized Views 01:04 Required Schema Objects 01:49 Context API 02:47 Example View 04:11 Example Usage If you have a questions, please submit it in the comments below! Here's some sample syntax: CREATE CONTEXT MY_CONTEXT USING CONTEXT_API; create or replace PACKAGE BODY context_api IS PROCEDURE set_parameter (p_name IN VARCHAR2, p_value IN VARCHAR2) IS BEGIN DBMS_SESSION.set_context(‘MY_CONTEXT’, p_name, p_value); END set_parameter; PROCEDURE set_parameter (p_context IN VARCHAR2, p_name IN VARCHAR2, p_value IN VARCHAR2) IS BEGIN DBMS_SESSION.set_context(p_context, p_name, p_value); END set_parameter; END context_api; exec context_api.set_parameter( ‘CUSTOMER_ID’, 100); SELECT order_number, order_amount, item_description, line_amount FROM V_ORA_PARAM_VIEW;