velll

SELECT sn.username, m.sid, m.type, 
        DECODE(m.lmode, 0, 'None', 
                        1, 'Null', 
                        2, 'Row Share', 
                        3, 'Row Excl.', 
                        4, 'Share', 
                        5, 'S/Row Excl.', 
                        6, 'Exclusive', 
                lmode, ltrim(to_char(lmode,'990'))) lmode, 
        DECODE(m.request,0, 'None', 

velll

create or replace type id_list as table of number
/
create table test_nested(
  id   number primary key,
  ids  id_list
)
nested table ids store as nested_ids
/
insert into test_nested(id, ids)
values (1, id_list(1, 2, 3))