Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select * from V$VERSION;


BANNER


Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

PL/SQL Release 11.2.0.2.0 - Production

CORE 11.2.0.2.0 Production

TNS for Linux: Version 11.2.0.2.0 - Production

NLSRTL Version 11.2.0.2.0 - Production


declare 
    type ntt1 is table of rowid;
    type ntt2 is table of rowid;
    type ntt3 is table of rowid;
    nt1 ntt1 := ntt1 ();
    nt2 ntt2 := ntt2 ();
    res ntt3; 
begin 
    res := nt1 multiset except nt2;
end;
/
ORA-06550: line 9, column 12:
PLS-00306: wrong number or types of arguments in call to 'MULTISET_EXCEPT_ALL'
ORA-06550: line 9, column 5:
PL/SQL: Statement ignored

declare 
    type ntt is table of rowid;
    nt1 ntt := ntt ('1','3','5');
    nt2 ntt := ntt ('1','2','3');
    res ntt; 
begin 
    res := nt1 multiset except nt2;
    dbms_output.put_line ('res.count='||res.count||' res(1)='||res(1));
end;
/
1 rows affected

dbms_output:
res.count=1 res(1)=5