17,086
社区成员
发帖
与我相关
我的任务
分享
declare
num number;
begin
for A IN (select COLUMN_NAME
from user_tab_columns
where table_name = 'TEST'
and data_type <> 'CLOB'
and data_type <> 'BLOB') LOOP
--dbms_output.put_line(A.COLUMN_NAME);
for B in (select count(*) as num
from TEST
where A.COLUMN_NAME like '%ell%') loop
IF B.NUM>0 THEN
dbms_output.put_line(A.COLUMN_NAME);
END IF;
end loop;
end loop;
end;