CREATE TABLE TUN
(
  ID NUMBER, 
  PARENT_ID NUMBER,
  K1 VARCHAR2(100),
  K2   VARCHAR2(100), 
  K3  VARCHAR2(100),  
  VALUE    VARCHAR2(100),
  CONSTRAINT PK_TUN_ID PRIMARY KEY (ID)
);

insert into TUN(ID,PARENT_ID,K1,K2,K3,VALUE)
values (1,null,null,null,null,'Value common');

insert into TUN(ID,PARENT_ID,K1,K2,K3,VALUE)
values (2,1,'class1',null,null,'Value class1');
               
insert into TUN(ID,PARENT_ID,K1,K2,K3,VALUE)
values (3,2,'class1','obj1',null,'Value class1 obj1');

insert into TUN(ID,PARENT_ID,K1,K2,K3,VALUE)
values (4,2,'class1','obj2',null,'Value class1 obj2');

insert into TUN(ID,PARENT_ID,K1,K2,K3,VALUE)
values (5,3,'class1','obj1','prop1','Value class1 obj1 prop1');

insert into TUN(ID,PARENT_ID,K1,K2,K3,VALUE)
values (6,3,'class1','obj1','prop2','Value class1 obj1 prop2');

select id, parent_id, rpad(' ', (level-1)*2) || VALUE, level, sys_connect_by_path(id, '/') path,K1,K2,K3
from TUN
connect by prior id = parent_id
start with parent_id is null