From the course: Oracle Database 19c: PL/SQL

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Creating functions

Creating functions - Oracle Database Tutorial

From the course: Oracle Database 19c: PL/SQL

Start my 1-month free trial Buy for my team

Creating functions

“

- [Instructor] You'll create many database objects, sometimes several in one day, but CREATE function will be one of the creates that will return dividends long after you've created it. A database function is a sequence of SQL and PL/SQL statements stored by name, in the database's data dictionary that you can call again later. And it can have zero arguments or dozens, but usually just a few. A function returns one value of any data type, even a pointer. It's also called a user function or a user defined function or a stored function. No matter what the name, it does the same thing and I just call it a function. Finally, it can be stored by itself in the data dictionary or stored along with many other procedures and functions in a package, a convenient grouping of procedures, functions, and associated variables. These function examples are short, but functions will generally be more complex, have parameters passed to them and have a declaration section. One thing that these very short…

Contents