JPA fuzzy query like Oracle and MySQL

mysql How to write it ：like %: Parameters %, See the figure below for details

 @Query(value = "select * from base_area where pcodes like %:pcodes% ", nativeQuery = true)
List<Area> findByIsDeletedAndPcodesLike(@Param("pcodes") String pcodes);

oracle How to write it ：like '%'||: Parameters ||'%', See the figure below for details

 @Query(value = "select * from base_area where pcodes like '%'||:pcodes||'%' ", nativeQuery = true)
List<Area> findByIsDeletedAndPcodesLike(@Param("pcodes") String pcodes);