PL/SQL tutorial 1: PL/SQL Block Types in Oracle Database By Manish Sharma

PL/SQL Tutorial 1 Answering The Questions
What are Blocks in PL/SQl and What are different Sections Such as Declaration, Execution and Exception handling In Pl/SQL
Blog :

►►►Let’s Get Free Uber Cab◄◄◄
Use Referral Code UberRebellionRider and get $20 free for your first ride.

►Make sure you SUBSCRIBE and be the 1st one to see my videos!
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on

You can also Email me at
for E-mail address please check About section

Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos

This is Manish from


Gani. Akhiladithya says:

Nice Videos It really Helpful for me…

Hemanth SP says:

where is the exception handling videos sir?

uzair siddiqui says:

very nice tutorials .its help me a lot ..sir can u send me a pl/sql book ..i am preparing for oca..

Husna A says:

Hi Manish,

First of all i would like to thank you for your wonderful videos. Really very helpful.
I am willing to take up the OCA certification. Can you please help to know how to register and with the syllabus.
Looking forward for your kind reply.


Martin Mato says:

Very easy to learn. Excellent videos Manish. I recommend these videos be the first stop for anyone new to pl/sql.

Mohammad Masbah Uddin Chowdhury says:

Great tutorials. You are a star man. Very big thanks.

nagaraj b says:

what is the use of anonymous block in plsql?

Arun kanth says:

Hi Manish,

Thanks for explaining about VARRAY .. I f u can give some examples on VARRAY that would be great…

naveen kumar says:

bro thanks a lot awesome videos on sql and plsql … but thing is that please upload all the topics of plsql videos such as package,procedures,functions etc….
please i need it because im preparing for interview as well as for certification ..
thanks ..

Toheed Masood says:

Manish kindaly upload Oracle Apps DBA Tutorials

kiran12 rajni says:

Great Job Manish.Explained with lot of Patience and your explanation is easy understanding

Zahoor James says:

Manish can u upload Oracle Apps DBA Tutorials

rupyes kaur says:

Hello , Munish Sir pl/sql block is use after create and insert the table in sql ?


Good Tutorial.Really very helpful.clean Explanation on each and every topic.This is the only good destination who are wanted to learn plsql.I am searching from past one year but not other series not like this.Great job manish sir.Can you please upload he videos in other technologies(like JAVA,web development)very helpful to us.Thank you manish sir.

saurabh yeole says:

My pl SQL class will begin tomorrow.. just wanted to go lil bit prepared . Found some video’s on YouTube but Ur video’s are the best.
Nice work

nasir baig says:

Sir its an excellent video, loving it. There is one minor typos, I believe it is DBMS_SQL not the DMBS_SQL.

Ademola afees says:

Manish Sharma, You’re a good teacher, very explanatory

Aakash Gupta says:

plese your uploded video to translate in hindi languge.

saurabh kumhar says:

sir can you help me with this…..getting a compilation errors.. 🙁

Create or replace trigger T2
after insert or delete or update on emp_salary_details for each row
Insert into emp_table_audit values(:new.emp_id , NULL ,user ,systimestamp, ‘INSERTION’);
Insert into emp_table_audit values(NULL , :old.emp_id ,user , systimestamp, ‘DELETION’);
Insert into emp_table_audit values(:new.emp_id , :old.emp_id , user , systimestamp, ‘UPDATION’);

R_shree Star says:

Hi Manish Sir,
My friend suggested to watch videos on SQL.
There are also video’s for Plsql, I would like to see Video’s on Oracle 11g Admin 1 & 2. You are explaining very well All basic & deeply explained. Sir please upload video’s. I have mailed you same before 6 month ago… plz plz plz Sir, Many online trainees also thinking same…

Prashant Tiwari says:

Hi Manish…I have never seen such wonderful explanation before…it is very easy to understand each and every concept of pl/SQL.Your way of describing the things is awesome…thanks a lot for your tutorial.

Samnang says:

Manish Sharma ,May you show how to back up and restore database in oracle ? hop you will

Bilal Shah says:

I have a confusion in my mind that what is the difference between oracle 10g and 11g…Are both same which is better??plzzzzzzzzz tell me

Sakib Mulla says:

Fantastic video

Emanuel Valdiviezo says:

Manish you are my hero!!! Thanks for all tutorial videos!!!

ridheen says:

wer is ur website address ???? i cant find it anywhere

bala venkareddy says:

i can learn easy and more thing please add interview Questions

pranjal choudhary says:

Do I have to take PL/SQL exam before taking up OCA DBA(1Z0-052) exam

Zohaib Khalid says:

upload Oracle Apps DBA Tutorials

Mohammad Newaz Sharif says:

Hi Manish, your tutorials are really understandable. Can you please make tutorials for postgres plsql.

girish chaudhari says:

Hi sir, please post the link for details.

Tufail Saudagar says:

thnq so much i was thinking to say u to upload pl/sql lecture
keep it up…….:)

Siddharth Jain says:

how to install sql plus ???

cwg says:

Thank you so much for this. I am trying to learn this from a book and it’s just not as effective as this. Also your fast cadence is very much appreciated. I typically use the YouTube functionality to speed up such videos to about this speed.

kulbhushan kuwar says:

Manish sir please provide next tutorials .
part 22,23,24 and also provide packages,cursor tutorials.

Praveen Saraogi says:

how much time will it take to learn php ?

Iván Conde says:

Excellent videos! Thanks a lot 😀

 Write a comment


Do you like our videos?
Do you want to see more like that?

Please click below to support us on Facebook!