Exercice

Combien de lignes renvoie l'avant-dernière instruction SELECT ?

CTRL+C pour copier, CTRL+V pour coller
1
SET AUTOCOMMIT OFF
2
CREATE TABLE T1 (A INTEGER);
3
4
INSERT INTO T1 VALUES (1);
5
INSERT INTO T1 VALUES (1);
6
INSERT INTO T1 VALUES (1);
7
SELECT * FROM T1;
8
COMMIT;
SET AUTOCOMMIT OFF
CREATE TABLE T1 (A INTEGER);

INSERT INTO T1 VALUES (1);
INSERT INTO T1 VALUES (1);
INSERT INTO T1 VALUES (1);
SELECT * FROM T1;
COMMIT;
CorrectionRecommencer