Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
How to see multiple values in new line in Oracle SQL
Summary:
Content (required):
I need to develop a BIP report for talent profiles. As per the business requirement, I need to display multiple values (Ex. Skills, Languages etc.) in new line within the same excel cell for each person.
Using Listaag I can display these values with comma delimiter. Tried '\n' in Listaag and it didn't work.
The output with Listaag -
Profileid Skills
--------- ------
10 Communication,Leadership
20 Computer Skills,Team Work
But how to display them in new line? I want the output to be like below -
Profileid Skills
--------- ------
10 Communication
Leadership
20 Computer Skills
Team Work
If anyone know how to achieve it, please let me know.
Tagged:
0