摘要: 测试 savepoint rollback to # SAVEPOINT p_1 指定保存点p_1 # ROLLBACK to p_1 指定回滚点p_1 # 中间执行失败会,保存到执行成功的位置,此时可以先commit # 然后从失败位置继续执行,执行成功后commit # start TRANSA 阅读全文
posted @ 2020-11-30 12:02 whysun 阅读(176) 评论(0) 推荐(0)
摘要: oracle 行转列例子 create table STUDENT_SCORE ( name VARCHAR2(20), subject VARCHAR2(20), score NUMBER(4,1) ); insert into student_score (NAME, SUBJECT, SCOR 阅读全文
posted @ 2020-11-30 11:47 whysun 阅读(714) 评论(0) 推荐(0)