Hello,
I have this result of query:
select ID, COM from mytable;
ID COM
--- ----
1 val1
2 val2
3 val3
10 val10
Note : COM column is a BLOB type
I would like to have this resulat:
ID-1 ID-2 ID-3 ID-10
---- ---- ----- ----
val1 val2 val3 val10
Have you a suggestion to convert columns to rows?
Thank you in advance