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

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

Blog :
Previous Tutorial
► Introduction To PL/SQL Function:
► PL/SQL Variables:
► PL/SQL Constants:
►►►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

This is Manish from


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);
area := height * width;
return area;

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:



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 Hats   Modeling TipsFooding   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   Vapes   GameplaysHigh 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