Insert sys_guid generated value via jooq DSL

Question

I need help with jooq DSL. How can be written in jooq DSL insert like this one: insert into t (c) values (sys_guid()); ? For oracle. Thanks

Answer 1

Whenever you're missing a feature / support for a vendor-specific expression in jOOQ, plain SQL templating is your help: https://www.jooq.org/doc/latest/manual/sql-building/plain-sql-templating

In your case, write:

DSL.using(configuration)
   .insertInto(T)
   .columns(T.C)
   .values(field("sys_guid()", T.C.getDataType()));