SQL> create tabletest_for_cdr(DD int, ORG_CODE int);
Table created
SQL> create or replace type numlist is table of int;
2/
Type created
SQL>
SQL> with t as
2 (select dd, cast(collect(org_code) as numlist) code_list
3from test_for_cdr
4 group by dd
5 order by dd)
6select dd, column_value
7from (select dd, code_list multiset EXCEPT next_code_list res_code_list
8
from (select dd,
9
code_list,
10
(select code_list from t where dd = next_dd) next_code_list
11
from (select dd,
12
code_list,
13
lead(dd) over(order by dd) next_dd
14
from t))),
15 table(res_code_list)
16/