IFS Connect is a simple integration framework yet you can do pretty nice things around it. This blog post explains such a trick done with IFS Connect for adding Media items into IFS and attach to a work order.
Oracle subquery using WITH clause is a popular choice among the developers. From Oracle 12C it’s possible to define PLSQL function inside WITH clause. It’s a handy feature which is really useful when making complex queries