1.create table ZJTSTEBD01 as select * from ZJTSYEBD where 1 = 0; ... ... create table ZJTSTEBD10 as select * from ZJTSYEBD where 1 = 0;create table ZJTSTEBD as select * from ZJTSYEBD2.desc ZJTSTEBD01 3.select count(*) from ZJTSYEBD
1. begin for i in 1..10 loop execute immediate 'create table ZJTSTEBD'||i||' as select * from ZJTSYEBD where 1<>1'; end loop; execute immediate 'create table ZJTSTEBD'||11||' as select * from ZJTSYEBD '; end;2. desc tablename;3. select count(1) from ZJTSYEBD
...
...
create table ZJTSTEBD10 as select * from ZJTSYEBD where 1 = 0;create table ZJTSTEBD as select * from ZJTSYEBD2.desc ZJTSTEBD01 3.select count(*) from ZJTSYEBD
1.
begin
for i in 1..10 loop
execute immediate 'create table ZJTSTEBD'||i||' as select * from ZJTSYEBD where 1<>1';
end loop;
execute immediate 'create table ZJTSTEBD'||11||' as select * from ZJTSYEBD ';
end;2. desc tablename;3. select count(1) from ZJTSYEBD