17,382
社区成员




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