使用数据库事务可以防止误操作
savepoint a;
delete from ISPACE_USER_INFO where MSISDN='18888888838';
SELECT * FROM ISPACE_USER_INFO WHERE MSISDN='18888888837';
rollback to a;
SELECT * FROM ISPACE_USER_INFO WHERE MSISDN='1524366238';
begin
savepoint a;
delete from ISPACE_USER_INFO where MSISDN='18888888838';
rollback to a;
END;
SELECT * FROM ISPACE_USER_INFO WHERE MSISDN='18888888838';s
详细解释:savepoint 为保存事务,rollback 回滚事务