declare
cursor cur is
select *
from tADM_sql_mst
order by sql_id; -- cntr
begin
for fet001 in cur loop
--if instr(fet001.sql_SENTENCE,'TADJ_COL_MST') > 0 THEN -- hload
if instr(fet001.sql_QRY,'TADJ_COL_MST') > 0 THEN -- CNTR
--DBMS_OUTPUT.PUT_LINE('SQL_ID :'||fet001.SQL_ID);
DBMS_OUTPUT.PUT_LINE('SELECT A.ROWID,A.* FROM TCMN_SQL_MST A WHERE A.SQL_ID='''||fet001.SQL_ID||''';');
END IF;
end loop;
end;