SELECT REF(alias)FROM nom_table alias0000280209DB703686EF7044A49F8FA67530383B36853DE7106BC74B6781275ABE5A553A5F01C000340000
DECLARE variable REF type_objet;
BEGINSELECT REF(alias) INTO variable
FROM table2 aliasWHERE clé_table2='valeur';
INSERT INTO tCours (champs1, ..., clé_étrangère)
VALUES ('valeur1', ..., variable);
END;DECLARE refI REF typIntervenant;BEGININSERT INTO tIntervenant (pknom, prenom)
VALUES ('CROZAT', 'Stéphane');
SELECT REF(i) INTO refI
FROM tIntervenant iWHERE pknom='CROZAT';
INSERT INTO tCours (pkannee, pknum, titre, type, debut, refintervenant)
VALUES ('2003', 1, 'Introduction','C', '01-JAN-2001', refI);
INSERT INTO tCours (pkannee, pknum, titre, type, debut, refintervenant)
VALUES ('2003', 2, 'Modélisation','TD', '02-JAN-2001', refI);
END;/