比如我有这么几条语句:
insert into user(username) value('a')
insert into user(username) value('b')
insert into user(username) value('c')
insert into user(username) value('d')
怎么样一点击执行按钮,这几句就会执行呢,难道让我一条一条的执行??
...全文
195320打赏收藏
PL/SQL developer 如何一次性执行多条语句??
比如我有这么几条语句: insert into user(username) value('a') insert into user(username) value('b') insert into user(username) value('c') insert into user(username) value('d') 怎么样一点击执行按钮,这几句就会执行呢,难道让我一条一条的执行??
不对,不信你全选它试试看,当然条件是你先建user表了
insert into user(username) values('a');
insert into user(username) values('b');
insert into user(username) values('c');
insert into user(username) values('d');
insert into user(username) value('a') ;
insert into user(username) value('b') ;
insert into user(username) value('c') ;
insert into user(username) value('d');
[/Quote]
不对,不信你全选它试试看,当然条件是你先建user表了
insert into user(username) values('a');
insert into user(username) values('b');
insert into user(username) values('c');
insert into user(username) values('d');
insert into user(username) value('a') ;
insert into user(username) value('b') ;
insert into user(username) value('c') ;
insert into user(username) value('d');
不对,不信你全选它试试看,当然条件是你先建user表了
insert into user(username) values('a');
insert into user(username) values('b');
insert into user(username) values('c');
insert into user(username) values('d');
insert into user(username) value('a') ;
insert into user(username) value('b') ;
insert into user(username) value('c') ;
insert into user(username) value('d');
[/Quote]
放到command中执行
insert into user(username) value('a');
insert into user(username) value('b');
insert into user(username) value('c');
insert into user(username) value('d');
commit;
insert into user(username) value('a') ;
insert into user(username) value('b') ;
insert into user(username) value('c') ;
insert into user(username) value('d');