Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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
testElham
Patient0021
oracle-cast-to-varchar-without-precision
Bcom
alle angemeldeten Benutzer können eine gegebene aktion ausgeben
emp
check if concatinated string obtained after reversing s1 and s2 both is a palindrome or not
SQLWithOuterAndInnerLoop_UnableToExecute
HELLO WORLD
Srinivas