PLSQL Block to generate list of all managers with their department & salary (Using Cursors Demo-4)

Published: 06 September 2022
on channel: Dr. Parag Shukla
501
9

This video practically demontrates that how to write the cursors to retrieve list of all managers with their department name and salary.

WRITE A PLSQL SQL BLOCK TO GENERATE THE FOLLOWING REPORT
-------------------------------------------------------------------------
LIST OF MANAGERS
-------------------------------------------------------------------------
EMPLOYEE NAME DEPARTMENT SALARY
--------------------------------------------------------------------------
KING ACCOUNTING 6000
CLARK ACCOUNTING 2940
SCOTT RESEARCH 3000
FORD RESEARCH 3000
JONES RESEARCH 2975
BLAKE SALES 2850
--------------------------------------------------------------------------
TOTAL SALARY: 20765
--------------------------------------------------------------------------


For Learning More about Programming
Subscribe to My Channel: https://www.youtube.com/c/drparagshuk...


Watch video PLSQL Block to generate list of all managers with their department & salary (Using Cursors Demo-4) online, duration hours minute second in high quality that is uploaded to the channel Dr. Parag Shukla 06 September 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 501 times and liked it 9 visitors.