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

symfony - TEST environment only: The database schema is not in sync with the current mapping file -

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -