sql - Oracle Display the values of columns in single row without using connect by clause -


this query

 select deptno,ename emp_task; 

output

enter image description here

i want output this

eno      ename 20    trinath/rabha 8     saikiran/kishore 10    kumar/vicky/dafni 

select deptno,        listagg(ename,'/') within group (order ename) names temp_task group deptno order deptno; 

Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

firemonkey - How do I make a beep sound in Android using Delphi and the API? -