Hello Lior, > First of all, we think your tool is very good.
Thank you > We are willing to use merge statement with where statement when > matched (Oracle support this merge_update_clause). > In your manual we saw that we can only use "whenMatchedThenUpdate". > > Did your tool support this feature of Oracle? Not yet. The current implementation only supports the SQL:2003 standard, which is implemented in HSQLDB: http://hsqldb.org/doc/2.0/guide/dataaccess-chapt.html#N12A31 There is a pending feature request to enhance the MERGE support for non standard extensions such as Oracle's (WHERE .. DELETE clause), DB2 / SQL Server / Sybase (Various extensions): https://sourceforge.net/apps/trac/jooq/ticket/545 This was a low priority so far, as I wasn't aware of any users actually using the MERGE statement, but I will increase priority for this to be implemented in 2.0.1 or 2.0.2... Specifically, the Oracle extension is rather simple Cheers Lukas
