Exercice
Quel est le résultat de l'exécution suivante sous Oracle ?
1
SET AUTOCOMMIT OFF
2
CREATE TABLE T1 (A INTEGER);
3
4
INSERT INTO T1 VALUES (1);
5
INSERT INTO T1 VALUES (2);
6
INSERT INTO T1 VALUES (3);
7
COMMIT;
8
INSERT INTO T1 (4);
9
INSERT INTO T1 (5);
10
ROLLBACK;
11
SELECT SUM(A) FROM T1
SET AUTOCOMMIT OFF CREATE TABLE T1 (A INTEGER); INSERT INTO T1 VALUES (1); INSERT INTO T1 VALUES (2); INSERT INTO T1 VALUES (3); COMMIT; INSERT INTO T1 (4); INSERT INTO T1 (5); ROLLBACK; SELECT SUM(A) FROM T1