You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
42 lines
742 B
42 lines
742 B
DROP TABLE ETUDIANT2020;
|
|
CREATE TABLE ETUDIANT2020(nom varchar2(100), age number);
|
|
INSERT INTO ETUDIANT2020 VALUES('Alice', 12);
|
|
INSERT INTO ETUDIANT2020 VALUES('Bob', 15);
|
|
INSERT INTO ETUDIANT2020 VALUES('Charlie', 18);
|
|
INSERT INTO ETUDIANT2020 VALUES('Dave', 21);
|
|
INSERT INTO ETUDIANT2020 VALUES('Eve', 11);
|
|
|
|
DROP TABLE tligne;
|
|
CREATE TABLE tligne(DESCRIPTION VARCHAR2(300));
|
|
|
|
|
|
SET echo off;
|
|
SET verify off;
|
|
SET feedback off;
|
|
|
|
DECLARE
|
|
Dnbmineur number;
|
|
MINEUR EXCEPTION;
|
|
|
|
BEGIN
|
|
SELECT count(*) into Dnbmineur
|
|
FROM ETUDIANT2020
|
|
WHERE AGE < 18;
|
|
|
|
IF (Dnbmineur > 0) THEN RAISE MINEUR;
|
|
END IF;
|
|
|
|
EXCEPTION
|
|
WHEN MINEUR THEN
|
|
INSERT INTO tligne VALUES(Dnbmineur);
|
|
|
|
END;
|
|
.
|
|
/
|
|
|
|
SET echo on;
|
|
SET verify on;
|
|
SET feedback on;
|
|
|
|
SELECT * FROM TLIGNE;
|