Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT imie, funkcja, szef1 "Szef 1", NVL(szef2, ' ') "Szef 2", NVL(szef3, ' ') "Szef 3"
- FROM (
- SELECT imie, funkcja,
- (SELECT imie FROM KOCURY_OB K WHERE K.pseudo=k2.szef) szef1,
- (SELECT imie FROM KOCURY_OB KK WHERE KK.pseudo = (SELECT szef FROM KOCURY_OB K WHERE K.pseudo = k2.szef)) szef2,
- (SELECT imie FROM KOCURY_OB KKK WHERE KKK.pseudo = (SELECT szef FROM KOCURY_OB KK WHERE KK.pseudo=( SELECT szef FROM KOCURY_OB K WHERE K.pseudo=k2.szef))) szef3,
- CONNECT_BY_ROOT imie Korzen
- FROM KOCURY_OB k2
- CONNECT BY PRIOR szef = pseudo
- START WITH funkcja IN ('KOT', 'MILUSIA'))
- WHERE Korzen = imie;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement