Long type 字段查询

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;