DIFFERENCE BETWEEN PROCEDURE AND FUNCTION IN ORACLE PL/SQL WITH EXAMPLE

The audio and video now synced.
This video is a free tutorial on the difference between procedure and a function. The tutorial demonstrates the difference between oracle PL/SQL stored procedure and a function, also it shows the different type of return statement in both of the database objects and various ways to execute a procedure and a function.
By learning the difference the users can make an effective judgment on when to use procedure and when to use a function.
If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below:
union and union all: • UNION AND UNION ALL SE...
char and varchar2: • DIFFERENCE BETWEEN CHA...
replace and translate: • Difference between Rep...
in and exists: • IN VS EXISTS VS JOIN, ...
rank and dense_rank: • Row Number Vs Rank Vs ...
delete and truncate: • Difference between Del...
%type and %rowtype: • What is %type and %row...

[@mahammaddarbardarbar8002]

Sir please make a video PLSQL sample project and explain please sir

[@vigneshsn7289]

Hi... Best page for SQL & PLSQL... Mostly I Covered all Videos Which n Your Page.. 👏 👏 👏
Requesting..!
Can u post videos about Performance Tunning, Index, External Table and Explain Plain In Your Style.. I'm waiting for It.. Can I have...?

[@TheSoulamimukherjee]

Is it possible to call a function in a dml statement , like how the function was called in a select stmt?

[@KishanMashru]

Yup it is very much possible, you can call the function in DML statements also.

[@TheSoulamimukherjee]

Kishan Mashru can you please give a small example

[@aayshachouhan6172]

volume of audio is very low...in fact in full volume i am not able to listen you..improve it..