This module covered the creation of a function using PL/SQL blocks and SQL commands.
You learned the basic syntax of a function and reviewed a detailed account of creating an example.
You created your own function for the course project and then used it within an UPDATE command.
You even practiced your documentation skills.
Now that you completed this module, you should be able to:
List the uses of a function and identify correct syntax
Create and execute a function that returns a number, text, or date value
List uses of a function that return a Boolean value
In this module you were introduced to the following glossary terms:
- Stored function
The next module looks at another type of stored PL/SQL object: the procedure.
Applications written in PL/SQL can run on any operating system and platform where
the Oracle database runs. With PL/SQL, you can write portable program libraries and
reuse them in different environments.
PL/SQL stored procedures move application code from the client to the server,
where you can protect it from tampering, hide the internal details, and restrict who has access.
For example, you can grant users access to a procedure that updates a table, but not grant them access to the table itself or to the text of the UPDATE statement.
Triggers written in PL/SQL can control or record changes to data, making sure that all changes obey your business rules.