Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ---
- create table ger61(
- id1 number(4),
- name varchar2(22),
- constraint ger61_id1_pk primary key (id1)
- );
- create table ger62(
- id2 number(4),
- id1 number(4),
- name varchar2(22),
- constraint ger61_id2_pk primary key (id2),
- constraint ger62_id1_fk foreign key (id1) REFERENCES ger61 (id1)
- );
- --- 61 is department
- insert into ger61 values (1, 'management');
- insert into ger61 values (2, 'management1');
- insert into ger61 values (3, 'management2');
- --- 62 projects
- insert into ger62 values (1, 2, 'bridge reconstruction');
- insert into ger62 values (2, 2, 'street reconstruction');
- insert into ger62 values (3, 2, 'HR');
- ---
- ---
- (select g1.name
- from ger61 g1)
- minus
- (
- select distinct g.name
- from ger61 g
- join ger62 g2 on (g2.id1 = g.id1)
- where exists (select distinct g2.id1
- from ger62 g2
- )
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement