Erreurs du chapitre 08


page 173, clause de démarrage du parcours récursif

WITH rec.tarecc
(niveau, libelle, lib_long, service, depend )
AS
( SELECT +1, b.libelle,b.libelle_long, b.service, b.depend_de
FROM db2.tarecc b
WHERE b.service IN ('0010', '0040', '0050')
UNION ALL
SELECT niveau+1, b.libelle,b.libelle_long, b.service, b.depend_de
FROM rec.tarecc r ,
db2.tarecc b
WHERE r.service = b.depend_de
AND r.service <> b.service
)
SELECT DISTINCT *
FROM rec.tarecc