PL/SQL tutorial 38: Introduction to PL/SQL functions in Oracle Database

PL/SQL tutorial for beginners Introduction to PL/SQL functions in Oracle Database by Manish Sharma
------------------------------------------------------------------------
►►►LINKS◄◄◄
Previous Tutorial
►
-------------------------------------------------------------------------
►►►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

___Facebook Official Page___

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

♥ I LOVE ALL, MY VIEWERS AND SUBSCRIBERS

[Scoopymc]

One of my favorite YouTube programming creators I’ve found in a long time. Keep up the great work!

[abdelmajidkansoussi]

this channel and code my school are among the channels to learn programming. Thank you Manish.

[sydneydileo]

All of these are so awesome! It is really helping me understand better before my test tonight. Thank you 🙂

[preetiwalia]

Hi Manish thank you very much for such a interactive videos they are great platform to learn Pl/SQL and i have gone through all of them. It will be great if you will help us with exception handling in Pl/SQL.

[jaspreetkathuria]

Question 1:
Create a procedure that accepts 3 parameters, the first two are of mode IN with number as
their datatype and the third one is of mode OUT in form of Varchar2. The procedure will
compare the first two numbers and output the result as EQUAL, or DIFFERENT.
Create a second procedure called L8Q1 that accepts the two sides of a rectangle. The
procedure will calculate the area and the perimeter of the rectangle. Use the procedure
created previously to display if the shape is a square or a rectangle. The following are the
example on how we execute the procedure and the expected output.

SQL > exec L4Q1(2, 2)
The area of a square size 2 by 2 is 4. It`s perimeter is 8.
SQL > exec L4Q1(2, 3)
The area of a rectangle size 2 by 3 is 6. It`s perimeter is 10.

[deepikajadhav]

Nice Explanation of Functions...Please add more videos related to Functions and Stored Procedures and there combined usage in packages..:)

[emanuelvald]

Manish thanks for upload your tutorials with subtitles!. I would like you upload a tutorial about collections PL SQL (Associative arrays, nested table and Varrays) and another one for Ref Cursors.

[jaspreetkathuria]

Create a pseudo function called pseudo_fun that accepts 2 parameters represented the
height and width of a rectangle. The pseudo function should return the area and the
perimeter of the rectangle.
Create a second procedure called L4Q2 that accepts the two sides of a rectangle. The
procedure will use the pseudo function to display the shape, the area and the perimeter.

SQL > exec L4Q2(2, 2)
The area of a square size 2 by 2 is 4. It`s perimeter is 8.
SQL > exec L4Q2(2, 3)
The area of a rectangle size 2 by 3 is 6. It`s perimeter is 10.

[shahrukhqureshi]

awesome bro big fan of urs and plz complete pl/sql tutorials fast

[jaspreetkathuria]

Project Part 4 3%
Question 1:
Create a procedure that accepts 3 parameters, the first two are of mode IN with number as
their datatype and the third one is of mode OUT in form of Varchar2. The procedure will
compare the first two numbers and output the result as EQUAL, or DIFFERENT.
Create a second procedure called L8Q1 that accepts the two sides of a rectangle. The
procedure will calculate the area and the perimeter of the rectangle. Use the procedure
created previously to display if the shape is a square or a rectangle. The following are the
example on how we execute the procedure and the expected output.
SQL > exec L4Q1(2, 2)
The area of a square size 2 by 2 is 4. It`s perimeter is 8.
SQL > exec L4Q1(2, 3)
The area of a rectangle size 2 by 3 is 6. It`s perimeter is 10.
Question 2:
Create a pseudo function called pseudo_fun that accepts 2 parameters represented the
height and width of a rectangle. The pseudo function should return the area and the
perimeter of the rectangle.
Create a second procedure called L4Q2 that accepts the two sides of a rectangle. The
procedure will use the pseudo function to display the shape, the area and the perimeter.
SQL > exec L4Q2(2, 2)
The area of a square size 2 by 2 is 4. It`s perimeter is 8.
SQL > exec L4Q2(2, 3)
The area of a rectangle size 2 by 3 is 6. It`s perimeter is 10.

[hirenpatel-cbvc]

what about "IN " "OUT" AND "INOUT" option with paramiter

[rishikeshpatahk]

Hi Manish can we insert update and delete data from function in oracle if yes please let us know how..

[abhisheku]

thanks for plsql can u please upload videos for form builder and report builder

[jaspreetkathuria]

Can you help me in solving these questions ?

[cambotourtech]

Please show the function return multiple rows/columns in Oracle sir.

[lansahibraheema]

i need triggers before and after updating