PL/SQL tutorial 39: How To Create PL/SQL Functions in Oracle Database By Manish Sharma

PL/SQL Tutorial for beginners on RebellionRider.com
How To Create PL/SQL Functions in Oracle Database

————————————————————————
►►►LINKS◄◄◄
Blog : http://bit.ly/how-to-create-pl-sql-function
Previous Tutorial
► Introduction To PL/SQL Function: https://youtu.be/6OJIrPx61mU
► PL/SQL Variables: https://youtu.be/2MNmodawvnE
► PL/SQL Constants: https://youtu.be/r1ypg7WH4GY
————————————————————————-
►►►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

https://twitter.com/rebellionrider
https://www.facebook.com/imthebhardwaj
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
http://rebellionrider.tumblr.com/
http://www.pinterest.com/rebellionrider/

___Facebook Official Page___
https://www.facebook.com/RebellionRider.official/

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 RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

Comments

santosh chary says:

Hello Manish…i have written the below code…it’s compiling with errors…plz suggest me what to do?

set serveroutput on;
create or replace function rect_area(height number(4),width number(4)) return number is
area number(4);
begin
area := height * width;
return area;
end;
/

error is :

Error(1,33): PLS-00103: Encountered the symbol “(” when expecting one of the following: := . ) , @ % default character The symbol “:=” was substituted for “(” to continue.
Error(1,48): PLS-00103: Encountered the symbol “(” when expecting one of the following: := . ) , @ % default character The symbol “:=” was substituted for “(” to continue.

Jonny Hawk says:

I have a question: What are those numbers next to “CONSTANT NUMBER”? I mean just the “(7,3)”
Good video friend, you’re awesome to explain that

Shahrukh Shahid says:

bro…..plz upload procedures

Abhishek Sharma says:

Manish, please do some videos on recovery and backup for Oracle 11g, using RMAN.

Humayun Kabir says:

nice

PAARAS MAKKAR says:

how do i create a function for table, say if am taking the input from a user..and i want to print the table for that number using a function created by me.

Write a comment

*

Human Verification: In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.


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

Please click below to support us on Facebook!

Send this to a friend

▷ Other ReviewsVehicles▷ Show Cars▷ Motorbikes▷ Scooters▷ Bicycles▷ Rims & Tires▷ Luxury BoatsFashion▷ Sunglasses▷ Luxury Watches▷ Luxury Purses▷ Jeans Wear▷ High Heels▷ Kinis Swimwear▷ Perfumes▷ Jewellery▷ Cosmetics▷ Shaving Helpers▷ Fashion HatsFooding▷ Chef Club▷ Fooding Helpers▷ Coktails & LiquorsSports▷ Sport Shoes▷ Fitness & Detox▷ Golf Gear▷ Racquets▷ Hiking & Trek Gear▷ Diving Equipment▷ Ski Gear▷ Snowboards▷ Surf Boards▷ Rollers & SkatesEntertainment▷ DIY Guides▷ Zik Instruments▷ Published Books▷ Music Albums▷ Cine Movies▷ Trading Helpers▷ Make Money▷ Fishing Equipment▷ Paintball Supplies▷ Trading Card Games▷ Telescopes▷ Knives▷ VapesHigh Tech▷ Flat Screens▷ Tech Devices▷ Camera Lenses▷ Audio HiFi▷ Printers▷ USB Devices▷ PC Hardware▷ Network Gear▷ Cloud Servers▷ Software Helpers▷ Programmer Helpers▷ Mobile Apps▷ Hearing AidsHome▷ Home Furniture▷ Home Appliances▷ Tools Workshop▷ Beddings▷ Floor Layings▷ Barbecues▷ Aquarium Gear▷ Safe Boxes▷ Office Supplies▷ Security Locks▷ Cleaning ProductsKids▷ Baby Strollers▷ Child Car Seats▷ Remote ControlledTravel▷ Luggages & Bags▷ Airlines Seats▷ Hotel Rooms▷ Fun Trips▷ Cruise Ships▷ Mexico Tours