Last answered:

09 Nov 2022

Posted on:

09 Nov 2022

0

Resolved: Rollback clause does not retrieve the last change

Hi Dear, You Are Very Nice and Professional. Thanks a bunch!!

First step:
I create new table as following:

CREATE TABLE departments_dup (
    dept_no CHAR(4) NOT NULL,
    dept_name VARCHAR(255) NOT NULL
);

Second step:
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
UPDATE departments_dup
SET
    dept_no = 'd010',
    dept_name = 'Quality Manager'

5st: rollback;
but i can not retrive first data

2 answers ( 1 marked as helpful)
Posted on:

09 Nov 2022

2

i find my answer :-)
i must be turn off toggle autocommite mode.
thanks

Instructor
Posted on:

09 Nov 2022

0

Hi Rasoul!

Thanks for reaching out!

Thank you for letting us know you can proceed with the course!

Good luck and please feel free to post another question should you encounter any difficulties. Thank you.

Best,
The 365 Team

Submit an answer