PLSQL procedure to generate report of employees hired in a given year (Using Cursors Demo-5)
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/drparagshukla?sub_confirmation=1
Видео PLSQL procedure to generate report of employees hired in a given year (Using Cursors Demo-5) канала Dr. Parag Shukla
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/drparagshukla?sub_confirmation=1
Видео PLSQL procedure to generate report of employees hired in a given year (Using Cursors Demo-5) канала Dr. Parag Shukla
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![PLSQL BLOCK - PRACTICAL DEMO OF FOR LOOP, NESTED FOR LOOP TO PRINT TRIANGLE AND PYRAMID](https://i.ytimg.com/vi/8SPuuOwtwyQ/default.jpg)
![Find first Max, Second Max & Third Max from N Nos given by user using Array in C](https://i.ytimg.com/vi/cmQRzMc680c/default.jpg)
![Java - final keyword with variable, method and class - Practical Demo](https://i.ytimg.com/vi/VOUD_24o0hM/default.jpg)
![Audio, Video & Camera App - Android Kotlin](https://i.ytimg.com/vi/UlwHdXLhcZk/default.jpg)
![interface in Java Part-2 (Methods, Constants, default, private and static methods) - Practical Demo](https://i.ytimg.com/vi/gqB3pMHAUwI/default.jpg)
![Java - Constructor & Method Overloading, Copy Constructor, Call By Value & Reference - Practical](https://i.ytimg.com/vi/wH-p5lkX45g/default.jpg)
![Java Array Part-3 (Search value from Array & Find First Max, Second Max & Third Max -Practical Demo)](https://i.ytimg.com/vi/Ahg-5E_pRPQ/default.jpg)
![Java JDBC - INSERT, UPDATE, DELETE in Oracle using Procedure calling from Java Callable Statement](https://i.ytimg.com/vi/uiU0tj2apBw/default.jpg)
![Basics of Algorithm & Programming (Nested Loops) - Lecture 16 | Gujarati](https://i.ytimg.com/vi/iZtFAKRRcls/default.jpg)
![Pointers in C - Part-1 - With explanation and Demonstrations](https://i.ytimg.com/vi/aCBEMpE425Q/default.jpg)
![OOP Fundamentals using Java Lecture - 5 (Primitive Types & Variables) | Gujarati](https://i.ytimg.com/vi/1vCFWo95S6w/default.jpg)
![Basics of Algorithm & Programming (Loops) - Lecture 9 | Gujarati](https://i.ytimg.com/vi/S9d7CPWxZpE/default.jpg)
![Java Exception Handling Part-3 (try with multiple catch and NumberFormatException) - Practical Demo](https://i.ytimg.com/vi/e0J2z0XrjHY/default.jpg)
![PLSQL Block to generate list of all managers with their department & salary (Using Cursors Demo-4)](https://i.ytimg.com/vi/SDYTQci2WaQ/default.jpg)
![Instead of Trigger in PLSQL Oracle - Part-2 (Practical Demo)](https://i.ytimg.com/vi/rcz-ioihbVM/default.jpg)
![Kotlin Basics - Defining a class with parameterized constructor and toString() fun - Practical Demo](https://i.ytimg.com/vi/yUDXm-vLCEs/default.jpg)
![Linked List Part - 7 (Count total no of nodes | total no student records in linked list) - PRACTICAL](https://i.ytimg.com/vi/jfpLV5VaHds/default.jpg)
![PLSQL Procedure to ask DeptNo from user and display the details of employees (Using Cursors Demo-1)](https://i.ytimg.com/vi/X2x9sMhTCoQ/default.jpg)
![Types of EditText -Android - AutoComplete & MultiAuto TextView, Date & Time Picker, Email Validation](https://i.ytimg.com/vi/xHgxg23P0-M/default.jpg)
![Material Design TextField TextInputLayout - Practical Demo - Android](https://i.ytimg.com/vi/4oMaH5tlsJI/default.jpg)