![](https://csdnimg.cn/release/download_crawler_static/7426371/bg8.jpg)
Like(判断符)(%)
SQL>insert into couple (DATA) values(TO_DATE('2012-08-
07','YYYY-MM-DD'))
2 where couple.name='Mr.zhang'; ??? 有错
TCL(事务控制语言)
Savepoint
Rollback
SQL> savepoint mark2;
保存点已创建。
SQL> savepoint mark2;
保存点已创建。
SQL> rollback to savepoint mark1;
回退已完成。
SQL> select *from couple;
NAME AGE ADDRESS BZ ID
-------------- ---------- -------------------- -------------------- ----------
DATA
--------------
Mr.zhang 20 湖南省邵阳市邵东县 handsome 001
SQL> select *from couple where name like 'Mr%';
NAME AGE ADDRESS BZ ID
-------------- ---------- -------------------- -------------------- ----------
DATA
--------------
Mr.zhang 20 湖南省邵阳市邵东县 handsome 001