看看这个行不行?create or replace procedure test is
begin
Insert Into sr (select atc.COLUMN_NAME, atc.TABLE_NAME
from all_tab_columns atc
where Upper(atc.TABLE_NAME) in ('A', 'B', 'C', 'D')) and Upper(sr.fname) <> Upper(atc.COLUMN_NAME) and Upper(sr.ftablename) <> Upper(atc.COLUMN_NAME)
end test;
begin
Insert Into sr (select atc.COLUMN_NAME, atc.TABLE_NAME
from all_tab_columns atc
where Upper(atc.TABLE_NAME) in ('A', 'B', 'C', 'D')) and Upper(sr.fname) <> Upper(atc.COLUMN_NAME) and Upper(sr.ftablename) <> Upper(atc.COLUMN_NAME)
end test;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货