可已删除
create table a (b number);
begin for i in 1..10 loop
insert into a values (i);
commit;
end loop;
end;
select * from a; 表a里有1到10的数字。
在R中执行:
> library(RODBC)
> c_lnyx
> sqlQuery(c_lnyx,'select * from a')
B
1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
10 10
> sqlQuery(c_lnyx,'delete from a where a.b=1')
character(0)
> sqlQuery(c_lnyx,'delete from a where a.b=1')
[1] "No Data"
> sqlQuery(c_lnyx,'delete from a where a.b=12')
[1] "No Data"
> sqlQuery(c_lnyx,'delete from a where a.b in (1,2,3,4,8)')
character(0)
> sqlQuery(c_lnyx,'select * from a')
B
1 5
2 6
3 7
4 9
5 10
SQL> select * from a;
B
----------
5
6
7
9
10
直接把数据库里的数据删掉了,都不用commit;