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

/* This is my query */

select deptno,ename from emp_task;

*/ Output */

enter image description here

/* I want the output like this */

eno      ename 

20    TRINATH/PRABHA

8     SAIKIRAN/KISHORE

10    KUMAR/VICKY/DAFNI

and so on.


Source: oracle

Leave a Reply