摘要: Merging into a Table: ExampleThe following example uses the bonuses table in the sample schema oe with a default bonus of 100. It then inserts into th... 阅读全文
posted @ 2015-05-15 14:59 seasonzone 阅读(210) 评论(0) 推荐(0) 编辑
摘要: SET TRANSACTION NAME 'Update salaries';SAVEPOINT before_salary_update;UPDATE employees SET salary=9100 WHERE employee_id=1234 # DMLROLLBACK TO SAVEPOI... 阅读全文
posted @ 2015-05-15 14:35 seasonzone 阅读(684) 评论(0) 推荐(1) 编辑