Oracle 18c

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

CREATE TABLE TEMP_TEST (
    CODE NUMBER,
    DATE_COL NUMBER,
    VAL NUMBER
);
begin
INSERT INTO TEMP_TEST (code, DATE_COL, val) values (1, 20210101, 1);
INSERT INTO TEMP_TEST (code, DATE_COL, val) values (1, 20210102, 2);
INSERT INTO TEMP_TEST (code, DATE_COL, val) values (1, 20210103, 3);
INSERT INTO TEMP_TEST (code, DATE_COL, val) values (2, 20210101, 4);
commit;
end;
/
1 rows affected

select date_col_data.DATE_COL, code_data.code
from
(SELECT distinct DATE_COL 
FROM TEMP_TEST ) date_col_data,
( SELECT distinct code 
FROM TEMP_TEST ) code_data



DATE_COL
CODE


20210101
2

20210101
1

20210103
2

20210103
1

20210102
2

20210102
1