Application of Oracle functions and stored procedures

For Oracle functions and stored procedures, Oracle provides many security mechanisms to control the access permissions of functions and stored procedures.

For Oracle functions and stored procedures, Oracle provides many security mechanisms to control the access permissions of functions and stored procedures.

Functions and stored procedures

In Oracle databases, you can use a single statement to add, delete, modify, and query a database. In addition, you can use multiple statements to form an I statement block and execute them together.
These statement blocks can be displayed and named and called by other applications. These named statement blocks are called functions and stored procedures.

Custom functions in Oracle;
Stored Procedures in Oracle;
Package functions and stored procedures-packages.

-- Function

-- A function is a common object in Oracle. Like other programming language functions, functions in Oracle must return a value. This is also an important feature that distinguishes functions from stored procedures.

-- Function introduction:
1. division of functions and functions
2. Function Parameters
3. function return value

Create a function