Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
OBIEE SQL and Listagg function
Summary
Need to display a list of degrees and certifications in a list for a reportContent
Hi all,
I am trying to produce a list of certifications and degrees for each employee in one record (hopefully separated by a semi-colon)
I have the query built to show the employee number, name and education (I built a UNION query) and then based on that I was trying to use the Listagg function.
I have read that it is not available if my query was using OTBI tables/views but I am using the actual tables.
Am I able to use this function? If not, is there a way to produce the list using a different method
1