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
Skip to content
  • 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.

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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