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

Опубликовано: 01 Октябрь 2024
на канале: 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...