LIKE clause in PL/SQL

[AOrehek]

Instead
SELECT
* FROM Table WHERE Name LIKE '%' + p_name + '%'

use

SELECT
* FROM Table WHERE Name LIKE '''%' || p_name || '%'''