How do I display SQL Query data on the page with Apex Oracle?
Did this: Create New Region -> Identification -> Type: Interactive Grid -> Source -> SQL Query, which contains select, inner join, group by, order by, but I get this error.
ORDER BY clause is not supported, use column sorting instead.
But I need the order by clause, else I get the wrong answer. SQL query works and returns the right answer in SQL Workshop -> Commands.
What are the ways around order by or should I use something else than interactive grid to show SQL data on the page?