Скачать или смотреть 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;