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

[@Scoopymc]

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

[@abdelmajidkansoussi6904]

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 🙂

[@Rebellionrider]

Really happy to be if help. All the best

[@preetiwalia2227]

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.

[@SinskariBoi3366three]

good tutorial for brush up

[@shahrukhqureshi1310]

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

[@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.

[@jaspreetkathuria343]

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.

[@deepikajadhav1038]

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

[@jaspreetkathuria343]

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.

[@SivaKumar-rv1nn]

Thankyou sir

[@jeetbhatt5986]

Your awesome.

[@Rebellionrider]

So do you 👍

[@theravibhardwaj88]

great work man!!

[@us9048]

thnx manish bhai thanks a lot.....

[@jaspreetkathuria343]

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-cb4vc]

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

[@Mortikus3]

I watch this for fun.

[@jaspreetkathuria343]

Can you help me in solving these questions ?

[@rishikeshpatahk2740]

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

[@abhishek4u19]

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

[@cambotourtech9237]

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

[@poojasahu5543]

i want to in Hindi

[@lansahibraheema752]

i need triggers before and after updating