Hi Sir,
Today my mgr asked me to write a sql query to display comma separated values with out using listagg, sys_connect_by_path, wm_concat ?
I said we can write only with cursor .. without oracle predefined functions? is it correct ? or any advise on this?
Please help me
Regards
Ar
SQL> create table samp(deptno number(2),ename varchar2(2));
Table created
SQL> insert all
2 into samp (deptno,ename) values (10,'A')
3 into samp (deptno,ename) values (20,'D')
4 into samp (deptno,ename) values (20,'E')
5 SELECT * FROM DUAL;
3 rows inserted
SQL> SELECT * FROM SAMP;
DEPTNO ENAME
------ -----
10 A
20 D
20 E
Need display like this
10 A
20 D,E