Advertisement
Guest User

LOVs

a guest
Dec 15th, 2019
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. -- ZAPOSLENIK_LOV
  2. select ime || ' ' || prezime dv
  3. ,zaposlenik_id rv
  4. from zaposlenik
  5. order by prezime
  6.  
  7. -- EDUKACIJA_LOV
  8. select naziv dv
  9. ,edukacija_id rv
  10. from edukacija
  11. order by naziv
  12.  
  13. -- Zadatak 17
  14. select e.naziv dv
  15. ,e.edukacija_id rv
  16. from edukacija e
  17. where not exists (select 1
  18. from zaposlenik_edukacija ze
  19. where ze.zaposlenik_id = :P6_ZAPOSLENIK_ID
  20. and ze.edukacija_id = e.edukacija_id)
  21. order by e.naziv
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement