Oracle: case with a tuple (object)

script.sql

create type ot_info is object (
    a number,
    b number,
    c number,
    map member function equals return raw
);
/

create type body ot_info as 

    map member function equals return raw as 
    
    begin
        --comparison logic taken from: http://www.oratable.com/oracle-object-type-comparison/
        return utl_raw.cast_to_raw(
              nvl(self.a, -1)
            ||nvl(self.b, -1)
            ||nvl(self.c, -1)
        );
    
    end equals;

end;
/

create table params (
    id number primary key,
    a number,
    b number,
    c number
);
/

insert into params values (1, 1,2,3);
insert into params values (2, 3,4,5);
insert into params values (3, 1,2,4);

select 
    id, 
    a,
    b,
    c, 
    case ot_info(a,b,c) 
        when ot_info(1,2,3) then 1
        else 0
    end decoded    
from params;

drop table params;

drop type ot_info;


--Script output
--
--Type OT_INFO compiled
--
--
--Type Body OT_INFO compiled
--
--
--Table PARAMS created.
--
--
--1 row inserted.
--
--
--1 row inserted.
--
--
--1 row inserted.
--
--
--        ID          A          B          C    DECODED
------------ ---------- ---------- ---------- ----------
--         1          1          2          3          1
--         2          3          4          5          0
--         3          1          2          4          0
--
--
--Table PARAMS dropped.
--
--
--Type OT_INFO dropped.