HomeОбразованиеRelated VideosMore From: Manish Sharma

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

416 ratings | 43899 views
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
Html code for embedding videos on your blog
Text Comments (12)
Sufyan Ansari (1 month ago)
Or you can simply write select circle_area(25) from dual.. :)
Manjunath Reddy (7 months ago)
Dear sir Please Provide Video 1)Pipelined function vs Table function 2)how to convert the non partition table to Partition Table 3)advantages of Partition 4)Normal table Verses Partition Table
Karthick Sivakumar (11 months ago)
thanks for both sql and plsql tutorials , you are really doing a great job sir
Humayun Kabir (1 year ago)
PAARAS MAKKAR (2 years ago)
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.
Jonny Marín (2 years ago)
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
Sharan V (2 years ago)
number(p,s)p=precision and s=scale.....For example, number(7,2) is a number that has 5 digits before the decimal and 2 digits after the decimal.
santosh chary (2 years ago)
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.
santosh chary (2 years ago)
Tnx Manish...it's worked for me..understood now :)
Manish Sharma (2 years ago)
Thanks for writing to me. The function is correct except that you specified the data width along with the datatype of your parameter. While defining the PL/SQL subroutines we do not write the data width, we only write the datatypes of their parameters. here is the correct code SET serveroutput ON; CREATE OR REPLACE FUNCTION rect_area( height NUMBER, width NUMBER) RETURN NUMBER IS area NUMBER(4); BEGIN area := height * width; RETURN area; END; / I suggest you , to watch the PL/SQL tutorial 38 carefully where I have explained the syntax https://youtu.be/6OJIrPx61mU Keep writing the code. All the best. Please do make sure to LIKE, SHARE and SUBSCRIBE. You can now also connect with me on my Facebook Personal Page: fb.me/TheRebellionRider Page for RebellionRider.com updates: fb.me/RebellionRider.official I am also very active on Twitter: https://twitter.com/RebellionRider Hope to see you there soon. Thanks and have a nice day.
Shahrukh Qureshi (2 years ago)
bro.....plz upload procedures
Abhishek Sharma (2 years ago)
Manish, please do some videos on recovery and backup for Oracle 11g, using RMAN.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.