Case Insensitive Sorting in APEX

By default Oracle does case sensitive sorting, which means that ascending order goes from A-Z then a-z. This is reflected in APEX when creating reports and sorting on them. They're various workarounds to enable case insensitive sorting. The simplest...