Debugging Question, correcting the below code CREATE TABLE tab1 (col1 CHAR(3), c

Question

Debugging Question, correcting the below code

CREATE TABLE tab1 (col1 CHAR(3), col2 CHAR(20)));
COMMIT;
INSERT INTO tab1 VALUES (123, 'Red');
INSERT INTO tab1 VALUES (456, 'Yellow');
SAVEPOINT s1 ON ROLLBACK RETAIN CURSORS;
DELETE FROM tab1 WHERE col1 = 132;
INSERT INTO tab1 VALUES (879, 'Blue');
ROLLBACK TO SAVEPOINT s1;
INSERT INTO tab1 VALUES (789, 'Green');
UPDATE tab1 SET col2 = ‘PURPLE’ WHERE col1 = 789;
COMMIT;

OUTPUT:

COL1                COL2

123                   Red
456                   Yellow
789                   -
3 record(s) selected

Explanation / Answer

Hi

I have fixed the systax issues and highlighted the code changes below.

CREATE TABLE tab1 (col1 number(3), col2 CHAR(20));
COMMIT;
INSERT INTO tab1 VALUES (123, 'Red');
INSERT INTO tab1 VALUES (456, 'Yellow');
SAVEPOINT s1;
DELETE FROM tab1 WHERE col1 = 132;
INSERT INTO tab1 VALUES (879, 'Blue');
ROLLBACK TO SAVEPOINT s1;
INSERT INTO tab1 VALUES (789, 'Green');
UPDATE tab1 SET col2 = 'PURPLE' WHERE col1 = 789;
COMMIT;
select * from tab1;

Output:

SQL> INSERT INTO tab1 VALUES (123, 'Red');

1 row created.

SQL> INSERT INTO tab1 VALUES (456, 'Yellow');

1 row created.

SQL> SAVEPOINT s1;

Savepoint created.

SQL> DELETE FROM tab1 WHERE col1 = 132;

0 rows deleted.

SQL> INSERT INTO tab1 VALUES (879, 'Blue');

1 row created.

SQL> ROLLBACK TO SAVEPOINT s1;

Rollback complete.

SQL> INSERT INTO tab1 VALUES (789, 'Green');

1 row created.

SQL> UPDATE tab1 SET col2 = 'PURPLE' WHERE col1 = 789;

1 row updated.

SQL> COMMIT;

Commit complete.

SQL> select * from tab1;

COL1 COL2
---------- --------------------
123 Red
456 Yellow
789 PURPLE

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.