#oracleplsql #oracleplsqljobs #oracleplsql #oracleplsqltutorial #oracleplsqldeveloperinterviewquestions #oracleplsqldeveloperinterviewquestions #oracleplsqland #oracleplsqlinterviewquestionsandanswers ✅PLSQL Session notes and interview questions✅ 👉WhatsApp group for SQL/PLSQL discussion✅ 📌Complete Informatica IICS Self-Paced Courses, and Interview Questions Links:* Are you interested in joining my Live training? or Self-Paced course? You can visit our website for more details. Feel free to contact me for more details @+917010080468 🌕 📌Chapters:📌 00:00:00 PLSQL tutorial for beginners 00:01:21 Introduction to PLSQL tutorial 00:12:56 What is an anonymous block in PLSQL?, what is a named block in PLSQL? 00:21:49 How to practice PLSQL in SQL developer? 00:29:08 Add two numbers in PLSQL code 00:55:11 What is constant in PLSQL variable? 00:58:01 What is not null in PLSQL variable? 01:01:30 Select statements in PLSQL block 01:10:58 DML statements in PLSQL block 01:17:53 Type and RowType in PLSQL Block 01:42:38 Conditional statements in PLSQL 01:48:58 IF statement in PLSQL block 02:02:33 CASE statement in PLSQL block 02:12:47 Looping statements in PLSQL 02:14:22 Simple loop in PLSQL 02:19:45 While loop in PLSQL 02:22:33 FOR loop in PLSQL 02:25:11 cursor in PLSQL 02:49:51 Types of Cursor in PLSQL 02:56:40 Explicit cursor in PLSQL 03:17:12 Cursor FOR loop in PLSQL 03:43:40 REF Cursor in PLSQL 04:00:13 Stored Procedure in PLSQL 04:36:36 Stored Procedure examples in PLSQL 05:04:19 Function in PLSQL 05:32:16 Functions- Examples in PLSQL 05:46:56 DML operations & Function Overloading in PLSQL 06:01:35 Packages in PLSQL 06:29:20 Difference between procedure and function 07:15:05 Autonomous Transaction in PLSQL 07:40:57 Triggers in Oracle 08:18:10 Instead of Trigger in PLSQL, Mutating table error in PLSQL 09:09:37 Collections in PLSQL 09:57:01 Bulk Collect in PLSQL 10:23:06 Dynamic SQL in PLSQL 10:42:11 Exception handling in PLSQL 11:05:56 Temporary tables in PLSQL ***************************************************************************** ✅ Oracle PL/SQL - Complete tutorial Playlist - ENGLISH✅ ✅ Oracle SQL - Complete tutorial Playlist - ENGLISH✅ Thanks, NiC IT Academy ========================================================== 📌 Oracle 21C Installation: with software: (How to import HR Schema in Oracle 21C) 📌 Oracle 11g Installation: (Oracle and SQL developer) ----------------------------------------------------------------------------------- 📌 Oracle SQL - Complete tutorial Playlist ***************************************************************************************************** 📌 Oracle SQL - Complete tutorial Playlist - ENGLISH 📌 Oracle SQL Day wise Video: ENGLISH Oracle SQL Tutorial - Day 1 - Oracle SQL Tutorial - Day 2 - Oracle SQL Tutorial - Day 3 - Oracle SQL Tutorial - Day 4 - Oracle SQL Tutorial - Day 5 - Oracle SQL Tutorial - Day 6 - Oracle SQL Tutorial - Day 7 - Oracle SQL Tutorial - Day 8 - Oracle SQL Tutorial - Day 9 - Oracle SQL Tutorial - Day 10 - Views in Oracle - Day 11 - Indexes in Oracle - Day 12 - Regular Expression - Day 13 - Merge Statement - Day 14 - ********************************************************************************** 📌 Oracle SQL Full Course in 6 hours - TAMIL Oracle Interview questions: sql interview questions and answers, sql server interview questions and answers, sql questions and answers,sql interview questions for testers, sql interview questions for freshers,sql interview questions pdf, sql interview questions for beginners,sql interview questions, sql interview questions for data analyst, sql interview questions youtube, sql interview questions for business analyst, sql interview questions for experienced, interview questions sql, oracle interview questions, sql interview questions, top 50 oracle interview questions, oracle interview questions , oracle interview questions for experienced,