PLSQL Tutorial#13 Key Points in Function and Procedure Difference in Procedure and function
In this Oracle PLSQL database tutorial, we will learn what is the difference between PLSQL Procedure and PLSQL function.
Following are the difference in PLSQL function and procedure
1 function is used to calculate results using given inputs, A procedure is used to perform certain tasks in order.
2 A function can be called by a procedure. A procedure cannot be called by a function.
3 DML statements cannot be executed within a function. DML statements can be executed within a procedure.
4 A function can be called within a query. A procedure cannot be called within a query.
5 Whenever a function is called, it is first compiled before being called. A procedure is compiled once and can be called multiple times without being compiled.
6 function returns a value and control to calling function or code. A procedure returns the control but not any value to the calling function or code.
7 A function has no support for try-catch A procedure has support for try-catch blocks.
8 select statements can have a function call. A select statement can't have a procedure call.
9 Explicit Transaction Handling A function can not have explicit transaction handling. A procedure can use explicit transaction handling.
Oracle SQL Complete Tutorial/Training/Course for the beginner:
• Tutorial#1 Basics Of Oracle SQL for B...
follow me on:
Facebook Page:
https://www.facebook.com/Equalconnect...
/ equalconnect
/ lrnwthr
Смотрите видео PLSQL Tutorial#13 Key Points in Function and Procedure Difference in Procedure and function онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь EqualConnect Coach 26 Июль 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 8,172 раз и оно понравилось 192 людям.