Declare tabName varchar2(30); colName varchar2(30); val varchar2(30); datType varchar2(30); vStr varchar2(300); Begin val := 'DALLAS'; datType := 'VARCHAR2'; for vTab in (select distinct(TABLE_NAME) as tabNa from user_tab_columns) loop tabName := vTab.tabNa; for vCol in (select COLUMN_NAME as colNa from user_tab_columns where TABLE_NAME = tabName and DATA_TYPE =datType) loop colName := vCol.colNa; begin vStr := 'update '||tabName ||' set '||colName||'='||colName||' where '||colName||'='''||val||''''; exception when others then null; end; execute immediate vStr; if SQL%rowCount > 0 then DBMS_OUTPUT.put_line(tabName||' '||colName||' '||val); end if; end loop; end loop; End; /
楼主【Object_yao1】截止到2008-07-23 00:47:02的历史汇总数据(不包括此帖):
发帖的总数量:2 发帖的总分数:200 每贴平均分数:100
回帖的总数量:1 得分贴总数量:0 回帖的得分率:0%
结贴的总数量:2 结贴的总分数:200
无满意结贴数:0 无满意结贴分:0
未结的帖子数:0 未结的总分数:0
结贴的百分比:100.00% 结分的百分比:100.00%
无满意结贴率:0.00 % 无满意结分率:0.00 %
敬礼!
tabName varchar2(30);
colName varchar2(30);
val varchar2(30);
datType varchar2(30);
vStr varchar2(300);
Begin
val := 'DALLAS';
datType := 'VARCHAR2';
for vTab in (select distinct(TABLE_NAME) as tabNa from user_tab_columns)
loop
tabName := vTab.tabNa;
for vCol in (select COLUMN_NAME as colNa from user_tab_columns where TABLE_NAME = tabName and DATA_TYPE =datType)
loop
colName := vCol.colNa;
begin
vStr := 'update '||tabName ||' set '||colName||'='||colName||' where '||colName||'='''||val||'''';
exception
when others then
null;
end;
execute immediate vStr;
if SQL%rowCount > 0 then
DBMS_OUTPUT.put_line(tabName||' '||colName||' '||val);
end if;
end loop;
end loop;
End;
/