Hi guys, I am fairly new in Oracle SQL, hopefully someone with more experience can help me solving this problem:
I have this table of Service:
And also this table of Service Test:
ID
| ID_Service
| Test_Date
|
|---|
| 1 | 1,2 | 01-01-2016 |
| 2 | 1 | 02-02-2016 |
Basically, I want to create a report in Oracle Apex with SQL, showing all of the Service Test data, but replacing the ID_Service with the name of the services. So the expected output is like this:
ID
| Service(s)
| Test_Date
|
|---|
| 1 | Fusion, Taleo | 01-01-2016 |
| 2 | Fusion | 02-02-2016 |
Is there a specific SQL function to replace the the comma-separated values with other values? Thank you in advance!
Danny