Oracle 11g Release 2

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

CREATE TABLE dummy_cust(
  id INT,
  NAME VARCHAR(50),
  age INT,
  country VARCHAR(50));
CREATE TABLE dummy_level(
  id INT,
  level_id INT,
  STATUS VARCHAR(50));
begin
INSERT INTO dummy_cust VALUES (1,'KIM',23,'US');
INSERT INTO dummy_cust VALUES (2,'KOM',24,'US');
INSERT INTO dummy_cust VALUES (3,'KING',29,'US');
INSERT INTO dummy_cust VALUES (4,'RAM',29,'US');
INSERT INTO dummy_cust VALUES (5,'RAV',23,'US');
INSERT INTO dummy_cust VALUES (6,'KIV',25,'US');

INSERT INTO dummy_level VALUES (1,21,'C');
INSERT INTO dummy_level VALUES (1,22,'C');
INSERT INTO dummy_level VALUES (1,24,'C');
INSERT INTO dummy_level VALUES (2,22,'C');
INSERT INTO dummy_level VALUES (2,23,'C');
INSERT INTO dummy_level VALUES (2,24,'C');
INSERT INTO dummy_level VALUES (3,21,'Z');
INSERT INTO dummy_level VALUES (3,22,'Z');
INSERT INTO dummy_level VALUES (4,21,'Z');
INSERT INTO dummy_level VALUES (4,22,'Z');
INSERT INTO dummy_level VALUES (4,24,'Z');
end;
/
1 rows affected

select *
  from dummy_cust c 
  join dummy_level  l using (id)
  pivot (max(level_id) lvl, max(status) sts 
         for level_id in (21 as l21, 22 as l22, 23 as l23, 24 as l24) )
  order by id ;


ID
NAME
AGE
COUNTRY
L21_LVL
L21_STS
L22_LVL
L22_STS
L23_LVL
L23_STS
L24_LVL
L24_STS


1
KIM
23
US
21
C
22
C
null
null
24
C

2
KOM
24
US
null
null
22
C
23
C
24
C

3
KING
29
US
21
Z
22
Z
null
null
null
null

4
RAM
29
US
21
Z
22
Z
null
null
24
Z

ID	NAME	AGE	COUNTRY	L21_LVL	L21_STS	L22_LVL	L22_STS	L23_LVL	L23_STS	L24_LVL	L24_STS
1	KIM	23	US	21	C	22	C	null	null	24	C
2	KOM	24	US	null	null	22	C	23	C	24	C
3	KING	29	US	21	Z	22	Z	null	null	null	null
4	RAM	29	US	21	Z	22	Z	null	null	24	Z