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.
