#oracleplsql #oracleplsqljobs #oracleplsql #oracleplsqltutorial #oracleplsqldeveloperinterviewquestions #oracleplsqldeveloperinterviewquestions #oracleplsqland #oracleplsqlinterviewquestionsandanswers
✅PLSQL Session notes and interview questions✅
https://nicitacademy.com/materials/psql/
👉WhatsApp group for SQL/PLSQL discussion✅
https://chat.whatsapp.com/I3SxzqfouLF61TGAUQeell
📌Complete Informatica IICS Self-Paced Courses, and Interview Questions Links:*
https://courses.nicitacademy.com/
Are you interested in joining my Live training? or Self-Paced course?
You can visit our website for more details.
https://www.nicitacademy.com/
Feel free to contact me for more details @+917010080468 🌕 https://wa.link/m4lat0
📌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✅
https://www.youtube.com/playlist?list=PLsphD3EpR7F_mXwcliOLEmnNUB7ZpxGdB
✅ Oracle SQL - Complete tutorial Playlist - ENGLISH✅
https://youtube.com/playlist?list=PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF
Thanks,
NiC IT Academy
==========================================================
📌 Oracle 21C Installation: with software: (How to import HR Schema in Oracle 21C)
https://youtu.be/xPSbxrMe7VU
📌 Oracle 11g Installation: (Oracle and SQL developer)
https://youtu.be/Jrefk1hOJQg
-----------------------------------------------------------------------------------
📌 Oracle SQL - Complete tutorial Playlist
https://youtube.com/playlist?list=PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF
*****************************************************************************************************
📌 Oracle SQL - Complete tutorial Playlist - ENGLISH
https://youtube.com/playlist?list=PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF
📌 Oracle SQL Day wise Video: ENGLISH
Oracle SQL Tutorial - Day 1 - https://youtu.be/hLnKjYGr730
Oracle SQL Tutorial - Day 2 - https://youtu.be/XpgjXvnfZec
Oracle SQL Tutorial - Day 3 - https://youtu.be/TmYqeFfHyyc
Oracle SQL Tutorial - Day 4 - https://youtu.be/tYQfBgUCpoI
Oracle SQL Tutorial - Day 5 - https://youtu.be/4qJJxQuHLC4
Oracle SQL Tutorial - Day 6 - https://youtu.be/CkaqluC2afE
Oracle SQL Tutorial - Day 7 - https://youtu.be/BSiCWzj-py8
Oracle SQL Tutorial - Day 8 - https://youtu.be/KtUCyG2cZe4
Oracle SQL Tutorial - Day 9 - https://youtu.be/B0JbGbWsEIA
Oracle SQL Tutorial - Day 10 - https://youtu.be/gRC3ndWLsoo
Views in Oracle - Day 11 - https://youtu.be/m8a1UtOmd5k
Indexes in Oracle - Day 12 - https://youtu.be/reL2O-kvNxc
Regular Expression - Day 13 - https://youtu.be/k_Eo08vLPhU
Merge Statement - Day 14 - https://youtu.be/NGN_jYisBJM
**********************************************************************************
📌 Oracle SQL Full Course in 6 hours - TAMIL
https://youtu.be/d04g-tnAxSQ
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,