[Home] [Help]
APPS.AMW_PURGE_MVIEW_LOG SQL Statements
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Line: 13
p_query := 'SELECT COUNT(1) FROM '||schema_name||'.'||table_name;
Line: 42
-- SELECT distinct mview_name, owner FROM sys.dba_mviews
--WHERE mview_name LIKE 'AMW_%';