Master Oracle PL/SQL in One Video | Beginner to Advanced (2026) [HINDI] | MPrashant

#mprashant #database #plsql ORACLE PL/SQL Course One Shot For Beginners Oracle PLSQL in One Video Learn PLSQL from Basic To Advance Masterclass Oracle PLSQL Oracle PLSQL for Beginners in HINDI in One Video Slides link - https://canva.link/u35gvx1cao1vau4 All queries - https://canva.link/zptn7dqdes8yfsc Video Timeline: 00:00 INTRO 00:53 Topics Overview 02:04 What is PLSQL? 07:40 PLSQL Installation on Windows 14:08 Import Sample DB on Windows 22:06 PLSQL Installation on MAC 27:37 Import Sample DB on MAC 36:06 Oracle Live SQL 37:42 PLSQL Block Structure 43:34 PLSQL Comments 45:56 PLSQL Variables 57:30 Overview of Datatypes 01:00:05 Anchored Variable Declaration 01:04:19 Constants in PLSQL 01:07:26 Operators & Expressions 01:14:25 SQL in PLSQL 01:15:52 SELECT INTO Statement 01:23:57 DML Operation in PLSQL 01:33:53 Control Structures 01:34:22 IF-ELSE in PLSQL 01:37:44 Comparison Operators 01: 39:17 IF-ELSE Usecase-1 01:41:26 IF-ELSE Usecase-2 01:43:21 IF-ELSE Usecase-3 01:46:38 Logical Operators 01:49:45 IF-ELSIF-ELSE Usecase 01:57:39 CASE in PLSQL 02:03:36 Loops in PLSQL 02:05:19 WHILE Loop in PLSQL 02:11:37 Basic Loop in PLSQL 02:16:06 FOR Loop in PLSQL 02:20:55 Exercise on Conditions & Loops 02:32:10 CONTINUE 02:35:24 Nested Block and Scope of Variables 02:39:17 Variable Shadowing 02:41:47 Composite Datatypes in PLSQL 02:42:23 Composite Datatypes - Records 02:44:01 Composite Datatypes - Records Type - ROWTYPE 02:49:35 Composite Datatypes - Records Type - User-defined Record Type 02:57:57 Composite Datatypes - Collections 02:59:29 Collection Types - VARRAY 03:15:48 Collection Types - Nested Table 03:27:20 Nested Table in DB Column 03:32:07 Collection Types - Associative Array 03:49:13 CURSOR in PLSQL? 04:03:51 Cursor Types - Explicit Cursor 04:08:22 Cursor Types - Implicit Cursor 04:11:09 Cursor with Parameters 04:14:01 FOR UPDATE & WHERE CURRENT OF 04:24:34 Transaction Control 04:28:26 Cursor Types - Reference Cursor 04:31:06 Exception Handling 04:39:33 Types of Exception Handling 04:48:23 User-Defined Exception 04:54:45 Non-Pre-Defined Exception 04:57:59 Raise Application Error 05:02:42 Types of Block 05:02:58 Anonymous Block 05:04:30 Named Block 05:05:46 PROCEDURES in PLSQL 05:10:44 Procedure with INPUT Parameters 05:13:26 Procedure with INPUT & OUTPUT Parameters 05:18:02 Exercise on Procedure 05:29:28 FUNCTIONS in PLSQL 05:36:16 Exercise on Function 05:41:49 PACKAGES in PLSQL 05:52:10 Package Variables 06:16:20 PACKAGE INITIALIZATION 06:25:20 PACKAGE Overloading 06:34:19 Exception Handling in Package 06:39:33 TRIGGERS in PLSQL 06:43:02 Create First Trigger 06:51:28 FOR EACH ROW in Trigger 06:54:18 FOR Clause, NEW & OLD 07:01:01 Exercise on Trigger 07:07:33 TRIGGER WHEN Clause 07:11:54 Enable,Disable Triggers 07:13:20 Compound Trigger 07:19:00 Handling Multiple DMLs in Trigger 07:21:28 Mutating Table Error 07:26:16 DYNAMIC SQL in PLSQL 07:32:04 Dynamic SQL Usecase 07:38:05 DDL Operations in PLSQL 07:41:00 BIND Variable 07:52:01 Oracle Supplied Packages 07:55:06 THE END