[Solved] oracle sql about table.substr

[ad_1]

Adjust your syntax to:

SELECT tableA.something
FROM tableA 
LEFT JOIN table
on tableA.name = substr(table.title, LENGTH(table.title)-8)

table.title is an argument to the LENGTH() function. Also needs to be argument to SUBSTR().

4

[ad_2]

solved oracle sql about table.substr