How to retrieve values from a column in comma seperated

login to sqlplus

sqlplus username/password@host:port/sid





SQL> create table emp(

2 emp_id number(10),

3 emp_name varchar2(10)

4 );

create table emp(

*

ERROR at line 1:

ORA-00955: name is already used by an existing object



SQL> drop table emp;



Table dropped.



SQL> create table emp(

2 emp_id number(10),

3 emp_name varchar2(10)

4 );



Table created.



SQL> insert into emp(emp_id,emp_name) values (1,'Tom');



1 row created.



SQL> insert into emp(emp_id,emp_name) values (2,'Dick');



1 row created.



SQL> insert into emp(emp_id,emp_name) values (3,'Harry');



1 row created.



SQL> commit;



Commit complete.

SQL> select * from emp;



EMP_ID EMP_NAME

---------- ----------

1 Tom

2 Dick

3 Harry



SQL> select rtrim(xmlagg(xmlelement (e, emp_name ',')).extract ('//text()'), ',') emp_name

2 from emp ;



EMP_NAME

--------------------------------------------------------------------------------

Tom,Dick,Harry



SQL> drop table emp;



Table dropped.

****Happy CoDiNg!!****