PLSQL Block to generate the report of dept wise no of employee & total salary (Using Cursors Demo-2)

Опубликовано: 03 Октябрь 2024
на канале: Dr. Parag Shukla
2,635
31

This video practically demonstrates that how to generate the following type of report using cursors. This is the details of department wise total no of employees and total salary.

PLSQL SQL BLOCK TO GENERATE THE FOLLOWING REPORT.
-------------------------------------------------------------------------------------------------
DEPARTMENT NO NO OF EMPLOYEE TOTAL SALARY
--------------------------------------------------------------------------------------------------
10 3 10500
20 5 10875
30 6 9400
--------------------------------------------------------------------------------------------------
TOTAL: 14 GRANT TOTAL: 30775
--------------------------------------------------------------------------------------------------


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