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

[@NehaSharma_nsds]

😊very very helpful video

[@Rebellionrider]

Thank you! 😊 I'm glad you found the video helpful! If you could quickly master any advanced SQL skill, what would it be and why? Your input enriches our content! 🌟🚀

[@karthicksivakumar4598]

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

[@islamicstatus8019]

Bro I Found Your Video On ChatGpt 🎉😂. Anyway Nice Video Bro ❤❤.

[@ericaleverson9430]

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

[@Rebellionrider]

Thank you so much. I am truly glad that you find my content helpful.

[@rahulpawar5927]

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

[@mdjuneed4271]

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

[@stoleterziev523]

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

[@dylang9790]

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

[@krishnavinod8734]

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

[@Rebellionrider]

This is the entire PL/SQL course. By the way Where do you currently stand in your SQL proficiency: beginner, intermediate, or advanced? Your perspective is valuable! 😊🌟

[@joylife3429]

Thanks very much, Sir.

[@manjunathreddy3484]

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

[@theBATfamiliar]

Thanks a lot for this tutorial :)

[@TargetMpset]

YOU ARE AMAZING MANISH !!!!

[@Rebellionrider]

Thank you so much your appreciation means a lot to me.

[@SivaKumar-rv1nn]

Thankyou sir

[@igaming_]

Are these syntax now also valid

[@Rebellionrider]

Of course they are.

[@Trendkanal]

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

[@sahanatrilochan4279]

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

[@abhisheksharma6617]

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

[@roshinimahesh5039]

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

[@praveenjohnwesley31]

function will always return a single value

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

[@palashbharati8818]

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;

[@shaheenshaikh6701]

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

[@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; ??

[@snowgaming.official]

set serveroutput on; declare v_result number (7,3); begin select Circle_area(25) into v_result from dual; dbms_output.put_line(v_result); end; /

[@makkar1610]

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.

[@youtuberatings611]

great video but your screen display is very tiny

[@punitkumar-oy2cl]

In function how I return data tabular form

[@shahrukhqureshi1310]

bro.....plz upload procedures

[@punitkumar-oy2cl]

I want to join function and table how

[@thesilentkiller3882]

why is your link not working?

[@santoshchary1631]

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.

[@Rebellionrider]

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 kzbin.info/www/bejne/bICteqWGrZtko7c 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: twitter.com/RebellionRider Hope to see you there soon. Thanks and have a nice day.

[@santoshchary1631]

Tnx Manish...it's worked for me..understood now :)

[@palashbharati8818]

create or replace function rectArea(l in float, b in float) return float is begin return (l*b); end; declare l float := 1.2; b float := 1.2; ans float; begin select rectArea(l,b) into ans from dual; dbms_output.put_line('Area of rectangle with l and b = ' || l || ', ' || b || ' = ' || ans); end;

[@raunaksahni6779]

hoye papa jiiiii

[@Rebellionrider]

Hey

[@DavidMartinez-im6ln]

The only thing I don't get it is why you haven't assigned a value to radius and still work

[@pixskull482]

He gave the value of radius (25) while he was calling functions in pl sql block

[@seulibera01]

How to update salary for each dept using function?

[@sufyanansari6096]

Or you can simply write select circle_area(25) from dual.. :)

[@gauravgupta9477]

He is trying to copy code with Harry style of speaking

[@aa_rav]

Yeh video 5-6 saal purani hai chomu.