How to display first name in single line?

Question

I'm learning oracle sql.

I'm just trying to display all the employees first name from 'Employee' table in single line with comma separation.

ex: john,alex,rosy

I'm using SQL*Plus for running the query.

Did you check this site?, this has more details on writing query to concatenate the rows. https://oracle-base.com/articles/misc/string-aggregation-techniques — Abhilash R Vankayala, Feb 17 '17 at 06:26
Possible duplicate of [How can I combine multiple rows into a comma-delimited list in Oracle?](http://stackoverflow.com/questions/468990/how-can-i-combine-multiple-rows-into-a-comma-delimited-list-in-oracle) — Aleksej, Feb 17 '17 at 08:22

score 0 · Accepted Answer · edited May 23 '17 at 12:25

0

You have to use some built in function like:

SYS_CONNECT_BY_PATH , ROW_NUMBER () OVER

Here is the solution

edited May 23 '17 at 12:25

Community

1
1

answered Feb 17 '17 at 06:27

720p Download Watch Dabangg 3

205
3
10

Thank you so much. Now i'm able to display first name in single line – Ramya jois Feb 17 '17 at 06:40
Great. Mark this as answer of your question so that others will find it helpful. – 720p Download Watch Dabangg 3 Feb 17 '17 at 07:58

score 0 · Answer 2 · answered Feb 17 '17 at 08:25

SQL> 
SQL> create table test(id int, name varchar(10));
Table created
SQL> begin
  2      insert into test values(1,'john');
  3      insert into test values(2,'alex');
  4      insert into test values(3,'rosy');
  5  end;
  6  /
PL/SQL procedure successfully completed
SQL> select listagg(name ,',')  within group(order by id) result from test;
RESULT
--------------------------------------------------------------------------------
john,alex,rosy
SQL> drop table test purge;
Table dropped

SQL>

How to display first name in single line?

2 Answers2