DBA Data[Home] [Help]

APPS.MSC_ANALYSE_TABLES_PK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 10

	SELECT	table_name,
                partitioned
	FROM	all_tables
	where 	owner=p_owner
        and     table_name like 'MSC%'
        and     temporary <> 'Y';
Line: 56

	SELECT	table_name,
                partitioned
	FROM	all_tables
	where 	owner=cv_owner
        and     table_name= UPPER(cv_table_name)
        and     temporary <> 'Y';