PLSQL - ORACLE

36 videos • 9,629 views • by Dr. Parag Shukla This playlist is for learners who want to learn PLSQL from scratch. If learners know the SQL, this is the perfect playlist for them to kick start in PLSQL. If you don't know SQL then first watch my playlist of SQL.
1
PLSQL BLOCK - PRACTICAL DEMO TO PRINT MESSAGE ON CONSOLE (Static Input, Dynamic Input, Verify off)
Dr. Parag Shukla
Download
2
PLSQL BLOCK - PRACTICAL DEMO OF IF ELSE STATEMENT TO CHECK CONDITION
Dr. Parag Shukla
Download
3
PLSQL BLOCK - PRACTICAL DEMO OF FOR LOOP, NESTED FOR LOOP TO PRINT TRIANGLE AND PYRAMID
Dr. Parag Shukla
Download
4
PLSQL Block to retrieve specified record from table - With Exception Implementation - Practical Demo
Dr. Parag Shukla
Download
5
Procedure to Insert Record in PLSQL - Practical Demonstration
Dr. Parag Shukla
Download
6
Procedure to Update Record in PLSQL with Implementation of Record Not Found - Practical Demo
Dr. Parag Shukla
Download
7
Procedure to Delete Record in PLSQL with Implementation of Record Not Found -Practical Demonstration
Dr. Parag Shukla
Download
8
SQL Script to Drop All the Created tables in Oracle including parent tables
Dr. Parag Shukla
Download
9
PLSQL Procedure to find given no is Positive, Negative or Zero - Practical Demo (Oracle)
Dr. Parag Shukla
Download
10
PLSQL Procedure to find given no is even or odd - Practical Demo in Oracle
Dr. Parag Shukla
Download
11
PLSQL Procedure to get the information of employee based on given employeeno with Exception - Part-1
Dr. Parag Shukla
Download
12
PLSQL Procedure to get information of Employee and Department based on given employee No - Part-2
Dr. Parag Shukla
Download
13
PLSQL Procedure to get information of ALL Employees (Cursor, Join & Exception) - Part-3
Dr. Parag Shukla
Download
14
PLSQL Procedure to ask DeptNo from user and display the details of employees (Using Cursors Demo-1)
Dr. Parag Shukla
Download
15
PLSQL Block to generate the report of dept wise no of employee & total salary (Using Cursors Demo-2)
Dr. Parag Shukla
Download
16
PLSQL Block to generate the report in format of Interview Call Letter - (Using Cursors Demo-3)
Dr. Parag Shukla
Download
17
PLSQL Block to generate list of all managers with their department & salary (Using Cursors Demo-4)
Dr. Parag Shukla
Download
18
PLSQL procedure to generate report of employees hired in a given year (Using Cursors Demo-5)
Dr. Parag Shukla
Download
19
PLSQL function to find given no is even or odd - (User Defined Function Demo-1)
Dr. Parag Shukla
Download
20
PLSQL function to find factorial of given no (User defined function Demo-2)
Dr. Parag Shukla
Download
21
PLSQL Package with procedure and function - Practical Demo (Oracle)
Dr. Parag Shukla
Download
22
PLSQL function to draw line based on given character and length (User defined function demo-3)
Dr. Parag Shukla
Download
23
PLSQL User defined function to find maximum salary of employee based on given deptno (UDF Demo-4)
Dr. Parag Shukla
Download
24
PLSQL user defined function to validate the email address using regular expression (Udf Demo-5)
Dr. Parag Shukla
Download
25
PLSQL user defined function to validate the password using Regular Expression (UDF Demo-6)
Dr. Parag Shukla
Download
26
PLSQL user defined function to find given no is manager or not (UDF Demo-7)
Dr. Parag Shukla
Download
27
PLSQL user defined function to check whether given string is lower or not (UDF Demo-8)
Dr. Parag Shukla
Download
28
PLSQL user define function to convert the date into desired format (UDF Demo-9)
Dr. Parag Shukla
Download
29
DML Trigger - To raise error when user enter salary less than 2000 - PLSQL Oracle (Trigger Demo-1)
Dr. Parag Shukla
Download
30
DML Trigger - To set the value of one column based on another column - PLSQL Oracle (Trigger Demo-2)
Dr. Parag Shukla
Download
31
Trigger to store information of employee into log whenever DML operation performed (Trigger Demo-3)
Dr. Parag Shukla
Download
32
Trigger which allows to perform DML operations only during business hours & between MONDAY TO FRIDAY
Dr. Parag Shukla
Download
33
Instead of trigger in PLSQL Oracle (Part-1) - Practical Demo
Dr. Parag Shukla
Download
34
Instead of Trigger in PLSQL Oracle - Part-2 (Practical Demo)
Dr. Parag Shukla
Download
35
System Trigger - Schema Trigger to get information of Log On in PLSQL Oracle - Practical Demo
Dr. Parag Shukla
Download
36
Database System Trigger to store information of logon and logoff of every user - Practical Demo
Dr. Parag Shukla
Download