Run Code
|
Code Wall
|
Users
|
Misc
|
Feedback
|
About
|
Login
|
Theme
|
Privacy
Recursive sql
--Oracle 11g Express Edition --please drop objects you've created at the end of the script --or check for their existance before creating --'\\' is a delimiter With ss as ( Select 1 as n, null as par, 'aa' as name from dual union all Select 2 as n, 3 as par, 'bb' as name from dual union all Select 3 as n, 4 as par, 'cc' as name from dual union all Select 4 as n, 1 as par, 'dd' as name from dual union all Select 5 as n, null as par, 'ee' as name from dual union all Select 6 as n, 1 as par, 'ff' as name from dual union all Select 7 as n, null as par, 'gg' as name from dual union all Select 8 as n, 6 as par, 'hh' as name from dual union all Select 9 as n, 5 as par, 'ii' as name from dual ) select level, connect_by_root n as root_n, n, par, name, listagg(n, '/') within group (order by level,par)over(partition by connect_by_root n) pat from ss Connect by par= prior n start with par is null
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
mr
pl/sql basic print hello world
Oracle Sandbox: Dog Data
oracle plan
Example of Local and Global variables
EMP
display student details in pl/sql
Somesh
IT
add of two num
Please log in to post a comment.