Thursday, May 14, 2020

oracle apex beginner tutorial - 3 || How to Create Dashboard in Oracle Apex

Code:
===
Select to_char(o.ORDER_TIMESTAMP,'Mon dd,yyyy') OrderDay,
sum(o.ORDER_TOTAL) sales
from demo_orders o
group by to_char(o.ORDER_TIMESTAMP,'Mon dd,yyyy'),order_timestamp
order by 2 desc nulls last
fetch first 5 rows only;

No comments:

Post a Comment