SQL query from MYSQL workbench not working in PL/SQL Developer

1

Hi,

i have a SQL query i made at home which worked on MYSQL Workbench but when trying to use at work it doesnt seem to accept CONCAT function so i tried removing that from query but then the other issue appears that i am missing a right parenthesis but i cant figure out whats wrong even though it says whats missing, i tried putting it in but to no success

SELECT

tag.TAG_NO ,
technical.DOC_NO 


FROM tag 
JOIN technical

ON TEMP_TITLE LIKE CONCAT  ('%',TAG_NO,'%')

WHERE tag.PROJECTNO = 'H707D001'
2 
SELECT

tag.TAG_NO ,
technical.DOC_NO 

FROM tag 
JOIN technical

ON technical.TEMP_TITLE LIKE '%' + tag.TAG_NO + '%'

WHERE tag.PROJECTNO = 'H707D001'
3

Thanks for your help, now it just says invalid number

4

OOPS, nvm, this is a SQL SERVER forum, so I assumed you would be going to SQL Server. Since you're using Oracle, it would something closer to:
...
ON technical.TEMP_TITLE LIKE '%' || tag.TAG_NO || '%'
...

5

thanks this worked!