1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| select count(SR.*)
from
(
SELECT kim.Name, kim.Fstname, kim.Num, kim.Cde
FROM contact kim, cpy, agent@lkkimcivi civ
WHERE kim.addr = cpy.addr
AND cpy.incde = '1000'
AND civ.codcol(+) = SUBSTR(kim.Cde,1,5)
AND To_Char(civ.codagt(+)) = SUBSTR(kim.Cde,7,5)
MINUS
SELECT kim.Name, kim.Fstname, kim.Num, kim.Cde
FROM contact kim, cpy, agent@lkkimcivi civ
WHERE kim.addr = cpy.addr
AND cpy.incde = '1000'
AND civ.codcol = SUBSTR(kim.Cde,1,5)
AND To_Char(civ.codagt) = SUBSTR(kim.Cde,7,5)
) SR |
Partager