Hello, Every org.jooq.Select type can be turned explicitly into a Field by using
- http://www.jooq.org/javadoc/latest/org/jooq/FieldLike.html#asField-- Hope this helps, Lukas 2014-09-03 18:41 GMT+02:00 <[email protected]>: > Hello, > > We have Oracle SQL code that is using a CASE statement with nested SELECTS > in the THEN & ELSE portions: > > > SELECT <fields>, > > CASE status > WHEN 'one' THEN status > WHEN 'two' THEN status > WHEN 'other' THEN <SELECT .... > > ELSE <SELECT> > > FROM <tables> > > > I tried converting using the decode() statement, however the .otherwise() > method didn't seem to support passing in select queries, only Strings or > Fields. > > ---------- > > One last question, our code calls user defined functions ex; > > > SELECT person.firstName, FindCourse(course_name) ... > > Is there any way to convert these to JOOQ? Would I just pass them in as > strings into my SELECT clause ? > > create.select(PERSON.FIRST_NAME, "FindCourse(course_name"), > PERSON.LAST_NAME, ....) > > Thanks! > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
