2015年5月15日
Merging into a Table: Example
摘要： 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 阅读(216) 评论(0) 推荐(0)
oracle 单独开始一个事物的写法 。
摘要： 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 阅读(697) 评论(0) 推荐(1)