How can i do a dinamic pivot table in SQl Developer ?

Question

I need to do a dinamic pivot with string caracteres but i don't know how to do it, can someone help me

Answer 1

Your question sounds interesting to me, but I do not know the precise answer. Based on this SO thread, maybe it's only possible with PL/SQL procedure.

https://stackoverflow.com/questions/15491661/dynamic-pivot-in-oracles-sql

But I am really curious, can you give more detail, what is the shape of your data and what do you want to display from it. Can you give an example?

Answer 2

I use Oracle SQL Developer for this.

I have someting like this:

COUNTRY_NAME EMPLOYEE
----------------------------------------------------
USA Elen Abel
USA Emilia Carolina
UK José Lopez
GERMANY David Austin
USA Sarah Bell
UK Alexis Bull

And i need to use pivot to order like this:

COUNTRY_NAME 1 2 3
----------------------------------------------------------------------------------------------
USA Elen Abel Emilia Carolina Sarah Bell
GERMANY David Austin NULL NULL
UK José Lopez Alexis Bull NULL