How to convert rows in column using SQL in Oracle

How to convert rows in column using SQL in Oracle;
for example
sl_no
1
2
3
4
output is 1234;
How to convert one column value into rows using SQL
for example
employee_name
Kumar
output
K
u
m
a
r

Questions by Sukanta2013

Showing Answers 1 - 3 of 3 Answers

Gayathri

  • Aug 28th, 2013
 

we can convert rows into columns using Decode or Case function

Kandavel Durairaj

  • Nov 8th, 2013
 

Using LISTAGG. Read the oracle documentation for more info.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions