GET_MV_DEPENDENCIES v14

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;