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

Published: 07 February 2017
on channel: Kishan Mashru
7,197
38

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


On this page of the site you can watch the video online DIFFERENCE BETWEEN PROCEDURE AND FUNCTION IN ORACLE PL/SQL WITH EXAMPLE with a duration of hours minute second in good quality, which was uploaded by the user Kishan Mashru 07 February 2017, share the link with friends and acquaintances, this video has already been watched 7,197 times on youtube and it was liked by 38 viewers. Enjoy your viewing!