Hey Guys, im planning to generate a report using stored procedure with cursor(if possible) to display the completed journey for top most desired to reached location which is (ToDestination) within my table, i just dont know how please help, thank you
Here is my table (Table Name : Booking)
I want to display something like this
SQL> exec summary_report;
=============================================================
Summary Report for top desired to reach location by customer
=============================================================
==================================================================
|Journey Status | Desired Location | Desired Location (COUNT) |
==================================================================
COMPLETED Pahang 3
COMPLETED Perak 3
COMPLETED Selangor 1
COMPLETED Perlis 1
COMPLETED Johor 1
COMPLETED Kelantan 1
=============================================================
END OF REPORT
=============================================================