sql循环更新
来源:互联网 发布:mysql source 导入文件 编辑:程序博客网 时间:2024/06/03 18:40
create table test_jumppoint
as
select RELATED_RESFDN,up_to_device from g_vrms_node_jointbox where up_to_device != -1
select * from test_jumppoint
create table test_TRANSO_NODE
as
select a.RELATED_RESFDN, b.RELATED_POSITION_POINT from test_jumppoint a, G_VRMS_TRANSO_NODE b where a.up_to_device = b.resfdn
select * from test_TRANSO_NODE
select * from G_VRMS_TRANSO_NODE
DECLARE P_INT NUMBER(38);
BEGIN
P_INT := 1;
FOR L_RECORD IN (select RELATED_RESFDN, RELATED_POSITION_POINT from test_TRANSO_NODE) LOOP
UPDATE G_VRMS_TRANSO_NODE_bak0619
SET RELATED_POSITION_POINT = L_RECORD.RELATED_POSITION_POINT
WHERE resfdn = L_RECORD.RELATED_RESFDN;
P_INT := P_INT + 1;
END LOOP;
END;
as
select RELATED_RESFDN,up_to_device from g_vrms_node_jointbox where up_to_device != -1
select * from test_jumppoint
create table test_TRANSO_NODE
as
select a.RELATED_RESFDN, b.RELATED_POSITION_POINT from test_jumppoint a, G_VRMS_TRANSO_NODE b where a.up_to_device = b.resfdn
select * from test_TRANSO_NODE
select * from G_VRMS_TRANSO_NODE
DECLARE P_INT NUMBER(38);
BEGIN
P_INT := 1;
FOR L_RECORD IN (select RELATED_RESFDN, RELATED_POSITION_POINT from test_TRANSO_NODE) LOOP
UPDATE G_VRMS_TRANSO_NODE_bak0619
SET RELATED_POSITION_POINT = L_RECORD.RELATED_POSITION_POINT
WHERE resfdn = L_RECORD.RELATED_RESFDN;
P_INT := P_INT + 1;
END LOOP;
END;
阅读全文
0 0
- SQL 循环更新
- sql循环更新
- 循环SQL删除(插入,更新)
- python循环更新sql语句
- T-SQL循环更新每一行
- sql server 2008 游标循环更新数据
- 利用游标循环进行更新插入的SQL事务语句
- 利用游标循环进行更新插入的SQL事务语句
- sql循环
- sql 循环
- 循环更新数据库 脚本
- 循环更新表字段
- java循环更新文件夹
- sql更新
- SQL更新
- SQL 更新
- SQL中游标使用--遍历数据逐行更新:相当于for循环
- sql创建一个表变量,并循环表,更新有一个字段
- 微信小程序的详细登录(上)
- 总结MongoDB采用MongoRepository进行查询
- 【javascript】深度复制
- Sublime Text 3解决中文乱码问题
- Ctags快速入门
- sql循环更新
- 76.[Docker]容器的数据管理
- 深度学习(07)_RNN-循环神经网络-02-Tensorflow中的实现
- 故障诊断的性能指标
- Mysql 控制台命令介绍
- 华为16道经典面试题
- 2016-6-19
- 线程通信之生产者消费者详解
- Unity 窗体透明