create hierarchical view tree type

Asked Jul 04 '19 at 02:59

Active Jul 04 '19 at 13:21

Viewed 27 times

From the table below, I need hierarchical view of fNAME, lNAME, USER_MAIL and PARENT_USERNAME, the path follows by lNAME/PARENT_USERNAME

create table USER (
USERNAME varchar2 (30),
fNAME varchar2 (30) not null,
lNAME varchar2 (30) not null,
USER_PHONE char(10) null,
USER_MAIL varchar2 (30) null,
PARENT_USERNAME varchar2 (30) null,
constraint USERNAME_PK primary key (USERNAME) );

edited Jul 04 '19 at 13:21

asked Jul 04 '19 at 02:59

Include sample data along with the results you're expecting with the question – MJoy Jul 04 '19 at 03:05
Ok, I did it :) thx, I though to mention only SQL :) – Jul 04 '19 at 13:21

create hierarchical view tree type

0 Answers0