https://sqlines.com/ 2026-05-06T14:30:57+00:00 https://sqlines.com/ https://sqlines.com/lib/images/favicon.ico text/html 2025-07-06T15:41:50+00:00 https://sqlines.com/java/dynamic_sql?rev=1751816510&do=diff Java applications can contain dynamic SQL statements in the native syntax of the source database (e.g., Oracle), which you need to convert to the native syntax of the target database (e.g., MySQL) during migration. Source - Oracle: // Native SQL in string StringBuilder sql = new StringBuilder("SELECT TRUNC(SYSDATE) FROM t"); Query query = entityManager.createNativeQuery(sql.toString()); query.getResultList();