Загрузка страницы

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
Показать
Комментарии отсутствуют
Введите заголовок:

Введите адрес ссылки:

Введите адрес видео с YouTube:

Зарегистрируйтесь или войдите с
Информация о видео
7 сентября 2022 г. 17:30:02
00:10:13
Другие видео канала
PLSQL BLOCK - PRACTICAL DEMO OF FOR LOOP, NESTED FOR LOOP TO PRINT TRIANGLE AND PYRAMIDPLSQL BLOCK - PRACTICAL DEMO OF FOR LOOP, NESTED FOR LOOP TO PRINT TRIANGLE AND PYRAMIDFind first Max, Second Max & Third Max from N Nos given by user using Array in CFind first Max, Second Max & Third Max from N Nos given by user using Array in CJava - final keyword with variable, method and class - Practical DemoJava - final keyword with variable, method and class - Practical DemoAudio, Video & Camera App - Android KotlinAudio, Video & Camera App - Android Kotlininterface in Java Part-2 (Methods, Constants, default, private and static methods) - Practical Demointerface in Java Part-2 (Methods, Constants, default, private and static methods) - Practical DemoJava - Constructor & Method Overloading, Copy Constructor, Call By Value & Reference - PracticalJava - Constructor & Method Overloading, Copy Constructor, Call By Value & Reference - PracticalJava Array Part-3 (Search value from Array & Find First Max, Second Max & Third Max -Practical Demo)Java Array Part-3 (Search value from Array & Find First Max, Second Max & Third Max -Practical Demo)Java JDBC - INSERT, UPDATE, DELETE in Oracle using Procedure calling from Java Callable StatementJava JDBC - INSERT, UPDATE, DELETE in Oracle using Procedure calling from Java Callable StatementBasics of Algorithm & Programming (Nested Loops) - Lecture 16 | GujaratiBasics of Algorithm & Programming (Nested Loops) - Lecture 16 | GujaratiPointers in C - Part-1 - With explanation and DemonstrationsPointers in C - Part-1 - With explanation and DemonstrationsOOP Fundamentals using Java Lecture - 5 (Primitive Types & Variables) | GujaratiOOP Fundamentals using Java Lecture - 5 (Primitive Types & Variables) | GujaratiBasics of Algorithm & Programming (Loops) - Lecture 9 | GujaratiBasics of Algorithm & Programming (Loops) - Lecture 9 | GujaratiJava Exception Handling Part-3  (try with multiple catch and NumberFormatException) - Practical DemoJava Exception Handling Part-3 (try with multiple catch and NumberFormatException) - Practical DemoPLSQL Block to generate list of all managers with their department & salary  (Using Cursors Demo-4)PLSQL Block to generate list of all managers with their department & salary (Using Cursors Demo-4)Instead of Trigger in PLSQL Oracle - Part-2 (Practical Demo)Instead of Trigger in PLSQL Oracle - Part-2 (Practical Demo)Kotlin Basics - Defining a class with parameterized constructor and toString() fun - Practical DemoKotlin Basics - Defining a class with parameterized constructor and toString() fun - Practical DemoLinked List Part - 7 (Count total no of nodes | total no student records in linked list) - PRACTICALLinked List Part - 7 (Count total no of nodes | total no student records in linked list) - PRACTICALPLSQL Procedure to ask DeptNo from user and display the details of employees (Using Cursors Demo-1)PLSQL Procedure to ask DeptNo from user and display the details of employees (Using Cursors Demo-1)Types of EditText -Android - AutoComplete & MultiAuto TextView, Date & Time Picker, Email ValidationTypes of EditText -Android - AutoComplete & MultiAuto TextView, Date & Time Picker, Email ValidationMaterial Design TextField TextInputLayout - Practical Demo - AndroidMaterial Design TextField TextInputLayout - Practical Demo - Android
Яндекс.Метрика