Next: 4.7 Utilisation des tables
Up: 4 Corps du programme
Previous: 4.5.3 FOR LOOP
  Contents
Ex : DECLARE
TYPE R_emp IS RECORD( nom VARCHAR(25) NOT NULL,
datnais DATE,
qualif personnel.qualif%TYPE );
v_emp R_emp;
BEGIN
v_emp.datnais := '24-MAR-38';
SELECT nom, datnais, qualif
INTO v_emp
FROM personnel
WHERE nom||prnm ='&nom'||'&prnm';
......
END;
Florence Bannay
2000-11-13