© 2026 LinearBytes Inc.
Search posts, tags, users, and pages
Louis Moreaux
Oracle APEX developer
Nice post, I would suggest the template directive option first because it keeps the SQL query cleaner. It can even be simplified
#JOB#{case JOB/}{when CLERK/} (STAFF){endcase/}