SQLWays changes CONCAT function to string concatination expression using ||.

Oracle:

select CONCAT('str1', 'str2') from t;  

HiRDB:

select 'str1' || 'str2' from t;   

References in Wiki