In this blog I am going to explain that how can get comma (,)
separate values from a column. For example aa,dd,cc etc . So here is point to
point explain.
- Create a Table
First of all I am creating a table which
contains direction so here table is “DIRECTION” .
2. Insert values
Here we are going to inserting directions in
table.
3. Get all data
4. Get comma separated values by concat strings
OUTPUT
5. Get comma separated values using COALESCE
function
Here we get same output as point no 4.