解决方案 »
- oracle服务问题
- 如何查询今天的数据?
- 请各位大神帮忙优化一下下面的一段SQL谢谢了
- 如何把Acess数据库导入Oracle数据库?谢谢
- Oracle的package
- 如何修改表中的字段名,原表中的数据要保留。SQL语句如何写?
- 数据表文件可以从Fat32转换为NTFS吗
- 一台unix机上oracle,windows里有许多字他没有,存储后变乱码,该如何解决?谢谢!!
- 哪儿有developer/2000 的下载(国内)啊?
- 关于group by 子句,如group by ‘string’ (string可为任意字符串)
- 急:关于bulk collect转换类型取值
- 从A表的字符字段转换数据插入到B表的数字字段
is
l_sql1 varchar2(1000);
l_sql2 varchar2(1000);
l_sql3 varchar2(1000);
l_sql4 varchar2(1000);
l_field1 varchar2(100);
l_field2 varchar2(100);
cursor c1 is select stblname,spkey,tpkey from syncdefine_table where tblname=p_tblname;
begin
for definers in c1
loop
l_sql2:='select * from '||definers.stblname||' where '||definers.tpkey||'='||p_value;
for sourcers in (select l_sql2 from dual)
loop
l_sql3:='select * from '||p_tblname||' where '||definers.tpkey||'='||p_value;
for targetrs in (select l_sql3 from dual)
loop
for syncrs in (select field,sfield from syncdefine_field where issync=-1 and tblname=p_tblname)
loop
l_field1:='sourcers.'||syncrs.sfield;
l_field2:='targetrs.'||syncrs.field;
if l_field1<>l_field2 then
l_sql4:='update '||p_tblname||' set '||l_field2||'='||l_field1||' where '||definers.tpkey||'='||p_value;
execute immediate l_sql4;
end if;
null;
end loop;
end loop;
end loop;
end loop;
end;
is
l_sql1 varchar2(1000);
l_sql2 varchar2(1000);
l_sql3 varchar2(1000);
l_sql4 varchar2(1000);
l_field1 varchar2(100);
l_field2 varchar2(100);
cursor c1 is select stblname,spkey,tpkey from syncdefine_table where tblname=p_tblname;
begin
for definers in c1
loop
l_sql2:='select * from '||definers.stblname||' where '||definers.tpkey||'='||p_value;
for sourcers in (select l_sql2 from dual)
loop
l_sql3:='select * from '||p_tblname||' where '||definers.tpkey||'='||p_value;
for targetrs in (select l_sql3 from dual)
loop
for syncrs in (select field,sfield from syncdefine_field where issync=-1 and tblname=p_tblname)
loop
l_field1:='sourcers.'||syncrs.sfield;
l_field2:='targetrs.'||syncrs.field;
if l_field1<>l_field2 then
l_sql4:='update '||p_tblname||' set '||l_field2||'='||l_field1||' where '||definers.tpkey||'='||p_value;
execute immediate l_sql4;
end if;
null;
end loop;
end loop;
end loop;
end loop;
end;
然后
for c in (select * from table_1 ) loopend loop;
l_sql2:='select * from '||definers.stblname||' where '||definers.tpkey||'='''||p_value||'''';