How to list the select from a materialized view
How to list the select from a materialized view
Execute the query below to list the select from a materialized view
set long 50000
--Col Text Word_Wrapped
--Set Heading Off
SELECT OWNER, MVIEW_NAME, query
FROM ALL_MVIEWS
WHERE OWNER LIKE UPPER('%&OWNER%')
AND MVIEW_NAME LIKE UPPER('%&MVIEW%')
ORDER BY MVIEW_NAME;
undef owner;
undef mview;