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 SET OPERATOR IN O...
char and varchar2: • DIFFERENCE BETWEEN CHAR AND VARCHAR2 ...
replace and translate: • Replace and Translate in sql
in and exists: • IN VS EXISTS VS JOIN, performance
rank and dense_rank: • Row Number, Rank and Dense Rank in sq...
delete and truncate: • Difference between Delete and Truncat...
%type and %rowtype: • type and rowtype PL/SQL | difference ...
Subscribe to the channel : / @kishanmashru
Other Playlists:
Data Warehousing Concepts: • Data Warehousing Concepts
Python and Database: • Python | How to Install python packages
SQL and PL/SQL Interview Questions: • SQL AND PL/SQL INTERVIEW QUESTIONS
SQL and PL/SQL concepts: • SQL and PLSQL
Content and video created by : Kishan Mashru
