Resolved: Rollback clause does not retrieve the last change
Hi Dear, You Are Very Nice and Professional. Thanks a bunch!!
I create new table as following:
CREATE TABLE departments_dup (
dept_no CHAR(4) NOT NULL,
dept_name VARCHAR(255) NOT NULL
copy all depatments table to new table
INSERT INTO departments_dup
SELECT * FROM departments;
3st step: Commit;
4st step: run update clause and change all rows to the following
dept_no = 'd010',
dept_name = 'Quality Manager'
but i can not retrive first data