BEGIN
UPDATE cus SET balance=balance-500 WHERE NAME='张三';
UPDATE cus SET balance=balance+500 WHERE NAME='李四';
COMMIT;
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line('转账失败');
rollback;
END;
回滚到某个事物点
UPDATE cus SET balance=balance+500 WHERE NAME='张三';
SAVEPOINT a;
UPDATE cus SET balance=balance+500 WHERE NAME='李四';
ROLLBACK TO a;
2 为单个变量赋值
DECLARE
sName VARCHAR2(20);--声明部分
BEGIN --开始
SELECT stuName INTO sName FROM student1 WHERE ID=1;--可执行部分
dbms_output.put_line('id为1的学生姓名为'||sName);
EXCEPTION ---处理异常部分
WHEN OTHERS THEN
dbms_output.put_line('失败');
END;--结束
Declare
s Varchar2(20);
Begin
Select stuname Into s From student1 Where Id=1;
dbms_output.put_line(s);
End;
1 事务创建事务BEGINUPDATE cus SET balance=balance-500 WHERE NAME='张三';UPDATE cus SET balance=balance+500 WHERE NAME='李四';COMMIT;EXCEPTION WHEN OTHERS THEN dbms_output.put_line('转账失败'); ro...