A function defines a collection of SQL statements. You can call a function in an SQL statement to get a return value from the execution.
Log on to OceanBase Developer Center (ODC) and click the name of the target connection to go to the corresponding connection management page. You can click Function in the left-side navigation pane to get a list of functions. In the function list, double-click the name of a function to go to the function management page, where you can view the basic information, parameters, and data definition language (DDL) statements of the function.
The database version must meet the following requirements:
| Database | Version |
|---|---|
| OceanBase Database in Oracle mode | V2.0.0 or a later version |
| OceanBase Database in MySQL mode | V2.0.0 or a later version |
This chapter describes in different topics the operations you can perform on function objects in ODC.