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

SQL>CREATE TABLE employee(

id NUMBER,

first_name VARCHAR2(20),

last_name VARCHAR2(20),

mgrid NUMBER,

salary NUMBER(7,2));

SQL>DESC employee

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;

SQL>UPDATE employee SET last_name = 'Tate'

WHERE id = 3;

SQL>UPDATE employee SET salary = 2000 WHERE salary < 2000;

SQL>SAVEPOINT A;

SQL>DELETE FROM employee;

SQL>SELECT * FROM employee;

SQL>Rollback to A;

SQL>SELECT * FROM employee;

SQL>DELETE FROM employee;

SQL>COMMIT;

SQL>SELECT * FROM employee;