SQL & PL/SQL

Hi Guys,

I have a requirement where I need to convert the output of a query from columns to rows at run time.

SELECT 123 KI1, 456 KI2, 789 KI3, 214 KI4 FROM DUAL;

This query execution is happening in a procedure and we don't know how many columns will be returned. Columns names are also unknown to us during the exceution. Requirement is to get the below output. Please do let me know how should I approach to this.

Thanks,

Kamal