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

How To Create PL/SQL Functions in Oracle Database

------------------------------------------------------------------------
►►►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

[karthicksivakumar]

thanks for both sql and plsql tutorials, you are really doing a great job sir

[krishnavinod]

Great 🎉🎉 we need more from plsql course in details anything u u missed in this series,

[ericaleverson]

I have to learn this for work. You're my hero!

[rahulpawar]

A very good channel to leran SQL n PL/SQl.

[stoleterziev]

Manish great tutorials, but one suggestion from me could you find some other opening phrase for your videos? Thanks

[mdjuneed]

thanks for providing plsql videos, i learnt a lot from you.

[dylang]

thank you so much for the such great series about pl/sql

[manjunathreddy]

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

[Trendkanal]

Is it possible to return a whole table in a function?

[MahadevPatil]

Hi Manish,
Please tell how to call procedures in plsql developer? The one you have showed in sql developer isn't wotki g in plsql dev'r. Please help me

[sahanatrilochan]

How to concate strings from a table using ceate or replace function

[makkar]

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.

[palashbharati]

create or replace function circleArea (r in number)
return float
is
pi constant number(4, 3) := 3.142;
begin
return (r * r)*pi;
end;

declare
r number := 4;
ans float;
begin
select circleArea(r) into ans from dual;
dbms_output.put_line('Area of cicle having radius ' || r || ' = ' || ans);
end;

[abhisheksharma]

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

[shaheenshaikh]

Sir plz tell functions without any parameter n how it works whts its use

[punitkumar-oycl]

In function how I return data tabular form

[AliasMeify]

Hi- great vid BUT how would you write the SELECT statement to call the example function in this video?? SELECT circle_area from dual; ??

[roshinimahesh]

Hi Manish, Can you explain how to create function which returns multiple values

[youtuberatings]

great video but your screen display is very tiny

[santoshchary]

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.