《Oracle 11g数据库编程入门与实战》习题答案 第五章

第五章 数据操纵与事务控制

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;

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11168/viewspace-1035529/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11168/viewspace-1035529/