Creating Functions - Oracle PL SQL Course - Lesson 24 | SQL courses

Duration:16:08 min

Summary: The Oracle database the creation of function to program complexes business logic with the PL/SQL Language. This video will discuss the details about the creation of functions in Oracle: the differences from procedures, the type of return values, what can and cannot be inside a function, the parameters types and how to execute the functions. A developer that know and understand how functions work inside the Oracle can develop several routines do help process the data and perform calculations that can be reused inside SQL statement, especially inside the columns list and the WHERE clause. The video also show some examples of functions that cannot be created due to SQL statements that are restricted inside a function.