MyBatis Invalid number of parameters for fuzzy query under Oracle database error

Article turned from: 68490265

Oracle Stitching Strings concat Small things to be aware of

In the SSM framework when writing code, because the database replaced by Oracle, when the fuzzy query data suddenly found an error

SELECT * from Sys_menu where URL like concat ('% ', #{rolename}, '% ')

The number of error parameters has been invalid, find the data on the Internet to find the Fuzzy query SQL statement or concat ('% ', ' s ', '% ') write this

But it turns out that the stitching of three parameters in Oracle that do not support concat needs to be corrected to

SELECT * from Sys_menu where URL like concat (concat ('% ', #{rolename}), '% ')

MyBatis Invalid number of parameters for fuzzy query under Oracle database error