Wednesday, 4 March 2015

LISTAGG -Simple Example

create table dummy_data(name varchar2(100),c1 varchar2(1))

insert into dummy_data values ('Ashif','d')

select * from dummy_data


select name,listagg(c1,'') within group (order by line_no asc)
from dummy_data group by name

No comments:

Post a Comment