oracle for in loop 两例
来源:互联网 发布:不用域名不备案 编辑:程序博客网 时间:2024/06/05 18:52
for in loop 壹:
1、搭建环境
create table ETL_DATE(DATE_CHAR VARCHAR2(8),DATE_DATE DATE);
select * from etl_date;
2、代码
DECLARE
v_date date;
BEGIN
EXECUTE IMMEDIATE 'truncate table etl_date';
for v_date in 20091001 .. 20091021 LOOP
INSERT INTO etl_date
(date_char, date_date)
SELECT v_date, to_date(v_date, 'YYYY-MM-DD') FROM dual;
END LOOP;
COMMIT;
END;
select * from etl_date;
3、删除环境
drop table etl_date;
注:仅适用于在一月之内的循环。
for in loop 贰:
1、搭建环境
create table SQLTEXT(TEXT VARCHAR2(100));
create table HZ(HZ_NAME VARCHAR2(3));
INSERT INTO hz(HZ_NAME)values(' ');
INSERT INTO hz(HZ_NAME)values('PRE');
INSERT INTO hz(HZ_NAME)values('CUR');
INSERT INTO hz(HZ_NAME)values('INS');
INSERT INTO hz(HZ_NAME)values('UPD');
select * from HZ;
2、代码
declare
P_TABLE_NAME varchar2(100) := 'CFA';
begin
for HZ in (select HZ_NAME from HZ) LOOP
insert into sqltext
select 'CREATE TABLE ' || REPLACE(P_TABLE_NAME, 'EDW', 'TMP') ||
HZ.HZ_NAME || ' AS select * from ' || P_TABLE_NAME ||
' where ROWNUM<1'
from dual;
END LOOP;
end;
select * from SQLTEXT;
3、清空环境
drop table SQLTEXT;
drop table HZ;
- oracle for in loop 两例
- oracle for in loop
- For loop in MakeFile
- oracle优雅for 循环插入 in loop insert
- Oracle/PLSQL: FOR Loop
- Oracle 'open cursor loop fetch into' and 'for in cursor loop'
- using for loop in ssh
- for in loop 循环语句
- for loop in python demo
- Oracle/PLSQL: CURSOR FOR Loop
- Js for in vs for loop
- Oracle for in loop循环时expression is of wrong type报错
- Obj-C: (loop) 优雅的for...in loop
- hasOwnProperty,Object.keys(),propertyIsEnumerable,for-in(loop)
- C++ STL erase in for loop
- Oracle中用For Loop 替代Cursor
- Oracle控制语句(if , loop , while , for)
- Oracle/PLSQL: FOR Loop 循环语句
- 设计模式六大原则(6):开闭原则
- Scoket:UDP通讯模型
- BACKUP DATABASE PLUS ARCHIVELOG
- Mongodb的用处
- Android 4.4(KitKat)中的设计模式-Graphics子系统
- oracle for in loop 两例
- [机器学习]基于OpenCV实现最简单的数字识别
- 一、Hibernate基础入门
- 桌面融合-投影融合原理
- PL/SQL安装步骤及中文乱码解决
- Linux 内核中宏 offsetof 与 container_of 的含义
- 代码安全
- Solaris11配置静态IP
- 垃圾回收调优及JVM参数详解