DBA Data[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_%';