如果是插入删除等操作可以这样一次执行:
begin
select rownum id from tem_e;
insert into tem_e values('2005-01-01', 0);
insert into tem_e values('2005-02-01', 0);
insert into tem_e values('2005-03-01', 0);
insert into tem_e values('2005-04-01', 0);
insert into tem_e values('2005-05-01', 0);
insert into tem_e values('2005-06-01', 0);
insert into tem_e values('2005-07-01', 0);
insert into tem_e values('2005-08-01', 0);
insert into tem_e values('2005-09-01', 0);
insert into tem_e values('2005-10-01', 0);
insert into tem_e values('2005-11-01', 0);
insert into tem_e values('2005-12-01', 0);
end;
begin
select rownum id from tem_e;
insert into tem_e values('2005-01-01', 0);
insert into tem_e values('2005-02-01', 0);
insert into tem_e values('2005-03-01', 0);
insert into tem_e values('2005-04-01', 0);
insert into tem_e values('2005-05-01', 0);
insert into tem_e values('2005-06-01', 0);
insert into tem_e values('2005-07-01', 0);
insert into tem_e values('2005-08-01', 0);
insert into tem_e values('2005-09-01', 0);
insert into tem_e values('2005-10-01', 0);
insert into tem_e values('2005-11-01', 0);
insert into tem_e values('2005-12-01', 0);
end;
begin
insert into tem_e values('2005-01-01', 0);
insert into tem_e values('2005-02-01', 0);
insert into tem_e values('2005-03-01', 0);
insert into tem_e values('2005-04-01', 0);
insert into tem_e values('2005-05-01', 0);
insert into tem_e values('2005-06-01', 0);
insert into tem_e values('2005-07-01', 0);
insert into tem_e values('2005-08-01', 0);
insert into tem_e values('2005-09-01', 0);
insert into tem_e values('2005-10-01', 0);
insert into tem_e values('2005-11-01', 0);
insert into tem_e values('2005-12-01', 0);
end;
create table customer
( cust_num number(3),
cust_name varchar2(30),
address varchar2(50));
comment on table customer is '客户表';
comment on column customer.cust_num is '客户编号';
comment on column customer.cust_name is '客户名称';
comment on column customer.address is '地址';在toad的SQL Editor中怎么一次实现,但是在oracle自带的工具Oracle SQL Developer就可以!