Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Generate a report using procedure with cursor ( ORACLE - PL/SQL)

User_LM22YAug 26 2021 — edited Aug 26 2021

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)
Tableforstack.PNG
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
=============================================================

Comments

Post Details

Added on Aug 26 2021
1 comment
425 views