17,377
社区成员
发帖
与我相关
我的任务
分享
select id,jm,lk from biao_a where id in
('01'.'02'.'03.'04'....................................................................................'260003',...............'1000000');.
create table c(
id VARCHAR2(20 BYTE)
);
declare
begin
for i in 1..10000
loop
insert into c values (i);
end loop;
end;
需要一个分号create table c(
id VARCHAR2(20 BYTE)
)
declare
begin
for i in 1..10000
loop
insert into c values (i);
end loop;
end;
01 02 03 你自己在前面加个0都可以了select id,jm,lk from biao_a where id (select id from temp)