You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI 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

edited Nov 16, 2021 10:21AM in Reporting and Analytics for HCM 2 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!