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;
Oracle for in loop 循环记录行
最新推荐文章于 2024-08-15 15:02:26 发布