17,377
社区成员
发帖
与我相关
我的任务
分享
create or replace procedure text
is
flag number;
begin
EXECUTE IMMEDIATE 'CREATE TABLE USER_TEMP
SELECT T.*,ROWNUM RN FROM USER T' ;
SELECT MAX(RN) INTO FLAG FROM DATA_COMPARE_ODS_TEMP;
For i in 1..FLAG loop
insert into DATA_COMPARE_ODS_TEMP
select t.name,
t.'para0'||i
from USER_TEMPt
WHERE RN = FLAG;
commit;
end loop;
end