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

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

954

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...