GET_MV_DEPENDENCIES v17
When given the name of a materialized view, GET_MV_DEPENDENCIES
returns a list of items that depend on the specified view. The signature is:
GET_MV_DEPENDENCIES( <list> IN VARCHAR2, <deplist> OUT VARCHAR2);
Parameters
list
list
specifies the name of a materialized view or a comma-separated list of materialized view names.
deplist
deplist
is a comma-separated list of schema-qualified dependencies. deplist
is a VARCHAR2
value.
Examples
This example displays a list of the dependencies on a materialized view named public.emp_view
.
DECLARE deplist VARCHAR2(1000); BEGIN DBMS_MVIEW.GET_MV_DEPENDENCIES('public.emp_view', deplist); DBMS_OUTPUT.PUT_LINE('deplist: ' || deplist); END;
- On this page
- Parameters
- Examples