第五章 数据操纵与事务控制
1．
SQL> CREATE TABLE employee(
id NUMBER,
first_name VARCHAR2(20),
last_name VARCHAR2(20),
mgrid NUMBER,
salary NUMBER(7,2));
2．
SQL> DESC employee
3．
SQL> INSERT INTO employee
VALUES (1, 'Rose', 'Tyler', 4, 1500);
SQL> INSERT INTO employee
VALUES (2, 'Martha', 'Jones', 4, 2200);
SQL> INSERT INTO employee
VALUES (3, 'Donna', 'Noble', 4, 1300);
SQL> INSERT INTO employee
VALUES (4, 'Doctor', 'Who', NULL,3500);
SQL> INSERT INTO employee
VALUES (5, 'Jack', 'Harkness', 1, 3000);
SQL> COMMIT;
4.
SQL> UPDATE employee SET last_name = 'Tate'
WHERE id = 3;
5．
SQL> UPDATE employee SET salary = 2000 WHERE salary < 2000;
SQL> SAVEPOINT A;
6．
SQL> DELETE FROM employee;
SQL> SELECT * FROM employee;
7．
SQL> Rollback to A;
SQL> SELECT * FROM employee;
8．
SQL> DELETE FROM employee;
SQL> COMMIT;
SQL> SELECT * FROM employee;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11168/viewspace-1035529/ ，如需转载，请注明出处，否则将追究法律责任。
