0

I have one table named htask with column name htaskName The values of htask may contain '|' seperate values like 12|55|27

I would like to split all of them and join each value with another table call stask stask includes two column htaskName and staskName.

I've already try rtrim but not succeeded

Database version: Oracle 9i

Trần Tuấn Phương
  • 11
  • 2
  • Please include sample data for the two tables as well as the output. – Tim Biegeleisen Jul 12 '18 at 08:20
  • 1
    `SELECT * FROM htask h INNER JOIN stask s ON ( '|' || h.htaskname || '|' LIKE '%|' || s.hTaskName || '|%' )` may be a lot easier than splitting the delimited column into rows and joining .... still would be a duplicate of [this](https://stackoverflow.com/a/46706561/1509264) and probably several others – MT0 Jul 12 '18 at 08:48
  • Thank you for your supporting. It works perfectly. – Trần Tuấn Phương Jul 12 '18 at 08:58

0 Answers0