<div id="codeSnippetWrapper"> <div style="border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: #f4f4f4; padding-left: 0px; width: 100%; padding-right: 0px; font-family: 'Courier New',courier,monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px" id="codeSnippet">
<pre style="border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: white; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: 'Courier New',monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px"> 

 dept (50,,);
 dept(deptno,dname) (60,);
 dept  *  dept  deptno = 20;
删除
  dept  deptno = 20;
  dept;
修改
 dept  dname = dname ||   deptno = 20;
修改语句完成后都可以回滚或提交，即rollback、；
;
  temp   *  dept;
;
查询，发现无法回滚；同样增删改后面运行grant/create语句也是无法回滚的；