58 of 62
MULTISET Example
udeclare
v_emp1_nt
number_nt;
v_emp2_nt
number_nt;
v_emp3_nt
number_nt;
begin
select empno bulk
collect into v_emp1_nt
u from emp where
sal>1000;
u select empno bulk
collect into v_emp2_nt
u from emp where
job!='MANAGER';
select v_emp1_nt multiset union distinct v_emp2_nt
into v_emp3_nt
from dual;
dbms_output.put_line('A OR B: '||v_emp3_nt.count);
select v_emp1_nt
multiset except distinct v_emp2_nt
into v_emp4_nt
from dual;
dbms_output.put_line('A MINUS B: '||v_emp3_nt.count);
select v_emp1_nt
multiset intersect distinctv_emp2_nt
u into v_emp5_nt
from dual;
dbms_output.put_line('A AND B: '||v_emp3_nt.count);
uend;