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; /
楼主【yao521】截止到2008-07-26 01:48:55的历史汇总数据(不包括此帖):
发帖的总数量:0 发帖的总分数:0 每贴平均分数:0
回帖的总数量:2 得分贴总数量:1 回帖的得分率:50%
结贴的总数量:0 结贴的总分数:0
无满意结贴数:0 无满意结贴分:0
未结的帖子数:0 未结的总分数:0
结贴的百分比:---------------------结分的百分比:---------------------
无满意结贴率:---------------------无满意结分率:---------------------
如何结贴请参考这里:http://topic.csdn.net/u/20080501/09/ef7ba1b3-6466-49f6-9d92-36fe6d471dd1.html
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;
/