PLSQL procedure to generate report of employees hired in a given year (Using Cursors Demo-5)

Published: 07 September 2022
on channel: Dr. Parag Shukla
954
13

This video practically demonstrates how to generate the report of employee hired in given year. In this video i used the concept of cursors and procedure

WRITE A PLSQL PROCEDURE TO ACCEPT THE YEAR AS INPUT FROM THE USER AND GENERATE THE FOLLOWING REPORT NOTE:YEAR MUST BE USERDEFINED

EMPLOYEES DETAILS FOR THE YEAR 1987
---------------------------------------------------------------------
NO NAME DESIGNATION BASIC
---------------------------------------------------------------------
7788 SCOTT ANALYST 3000
7876 ADAMS CLERK 1100
---------------------------------------------------------------------
NO OF EMPLOYEES : 2 TOTAL : 4100
--------------------------------------------------------------------

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


Watch video PLSQL procedure to generate report of employees hired in a given year (Using Cursors Demo-5) online, duration hours minute second in high quality that is uploaded to the channel Dr. Parag Shukla 07 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 954 times and liked it 13 visitors.