Toad的SQL Editor为什么只能运行一条sql语句!
是否可以通过设置toad的参数,使taod的SQL Editor可以运行多条语句?
------解决方法--------------------------------------------------------
不能,只能一条条执行。选定一条按F9。
------解决方法--------------------------------------------------------
如果是插入删除等操作可以这样一次执行:
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;
------解决方法--------------------------------------------------------
F5可以执行批处理!要不就只有选种一条执行一条了
------解决方法--------------------------------------------------------
三个执行按纽中不是有个执行多条语句的快截方式吗???
用那个就应该可以的