CREATE TABLE new_emp ( employee_id NUMBER, name VARCHAR2(30)); 
 INSERT INTO new_emp SELECT employee_id , last_name FROM 
 employees; 
 SAVEPOINT s1; 
 UPDATE new_emp SET name = UPPER(name); 
 SAVEPOINT s2; 
 DELETE FROM new_emp; 
 ROLLBACK TO s2; 
 DELETE FROM new_emp WHERE employee_id =180; 
 UPDATE new_emp SET name = 'James'; 
 ROLLBACK TO s2; 
 UPDATE new_emp SET name = 'James' WHERE employee_id =180; 
 ROLLBACK; 

Show comments for this question (1)
Add comments
Link to this question