Advertisement
meshdev

sample way

Feb 20th, 2019
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. ---
  2. create table ger61(
  3. id1 number(4),
  4. name varchar2(22),
  5. constraint ger61_id1_pk primary key (id1)
  6. );
  7. create table ger62(
  8. id2 number(4),
  9. id1 number(4),
  10. name varchar2(22),
  11. constraint ger61_id2_pk primary key (id2),
  12. constraint ger62_id1_fk foreign key (id1) REFERENCES ger61 (id1)
  13. );
  14. --- 61 is department
  15. insert into ger61 values (1, 'management');
  16. insert into ger61 values (2, 'management1');
  17. insert into ger61 values (3, 'management2');
  18. --- 62 projects
  19. insert into ger62 values (1, 2, 'bridge reconstruction');
  20. insert into ger62 values (2, 2, 'street reconstruction');
  21. insert into ger62 values (3, 2, 'HR');
  22.  
  23. ---
  24. ---
  25. (select g1.name
  26. from ger61 g1)
  27. minus
  28. (
  29. select distinct g.name
  30. from ger61 g
  31. join ger62 g2 on (g2.id1 = g.id1)
  32. where exists (select distinct g2.id1
  33. from ger62 g2
  34. )
  35. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement