oracle unpivot function

The Oracle UNPIVOT clause allows you to transpose columns to rows. The UNPIVOT clause is opposite to the PIVOT clause except that it does not de-aggregate data during the transposing process. [...]

Apex String Split with APEX_STRING.SPLIT

This is very helpful.  optimizing-member-of-with-apex_string.split_ is a great utility that allows you to take a delimited list and make it query able. By help of this you can split comma (,), [...]

Start typing and press Enter to search