--
createorreplaceprocedurePF_ETL_DropBITempTableasBEGINdeclareCURSORcur_tableisselecttable_namefromall_tableswhereowner='NCOLAP'andTable_Namelike'BI_%';
row_table cur_table%ROWTYPE;
s_sqlvarchar2(2000);BEGINOPENcur_table;FETCHcur_tableINTOrow_table;WHILEcur_table%FOUND
LOOP
dbms_output.put_line(row_table.table_name);
s_sql :='drop table'||row_table.table_name;
dbms_output.put_line(s_sql);EXECUTEIMMEDIATE s_sql;FETCHcur_tableINTOrow_table;ENDLOOP;closecur_table;END;END;--exec PF_ETL_DropBITempTable--select * from DIM_TEMPLATE
