Erreurs du chapitre 08
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