Hello Lior, Ticket #998 has been implemented on SVN Trunk and Github. It adds Oracle's extensions to the standard MERGE statement, as specified here: http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9016.htm
These extensions mainly include WHERE and DELETE clauses: WHEN MATCHED THEN UPDATE .. WHERE .. DELETE WHERE .. WHEN NOT MATCHED THEN INSERT .. WHERE .. It will be included in the next 2.0.1-SNAPSHOT version: https://sourceforge.net/apps/trac/jooq/ticket/998 There will also be a couple of additional API features and integration tests to make MERGE statement support more robust: https://sourceforge.net/apps/trac/jooq/ticket/999 (Both WHEN clauses are optional) https://sourceforge.net/apps/trac/jooq/ticket/1000 (MySQL INSERT SET syntax for additional typesafety and convenience) DB2 / SQL Server / Sybase extensions might be out of scope for jOOQ 2.0.1. https://sourceforge.net/apps/trac/jooq/ticket/545 Version 2.0.1 will be released at the end of next week. Cheers Luks 2011/12/15 Lukas Eder <[email protected]>: > 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
