Manage functions

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, you can view the structure tree of an object, or right-click the target object to perform some management actions on the object. You can also double-click the name of the target function to go to the function management page.

Structure tree

You can click the expand icon before the name of the target function in the function list, and the structure tree of the function is displayed in a drop-down list, as shown in the following figure. The structure tree of a function can have up to three levels. When you right-click an item in the tree, the shortcut menu displays some actions that you can perform on the item. For more information about these actions, see the Management actions section. In this section, you can find the table describing the management options.

Management actions

The names of function objects support ascending order by the head character by default in the function list.

Shortcut function

The following functions are provided in the upper right corner of the tree:

Action	Description
Create	Click this option to create function.
Filter	Click this option to display valid/invalid functions.
Batch Compile	Click this option to batch compile the function object. Including: compile all objects and compile invalid objects.
Refresh	Click this option to refresh the structure tree after you perform management actions on the function, so that the structure tree displays the latest information.

Right-click function

After you right-click an item in the structure tree, a shortcut menu appears and displays some actions that you can take to manage the item. The following table describes the management actions in details:

Function management page

You can double-click the name of the target function in the function list to go to the function management page. The function management page displays the following information:

Section	Description
Basic Information	This section displays the basic information about the function in fields such as Function Name , Return Type , and Created By.
Parameter	This section displays the information about the parameters in fields such as Name , Order , Mode , Data Type , and Default Value . Click the icon to refresh the parameters.
DDL	This section displays the script that defines the function and provides the Edit, Download, Find, and Refresh icons. Note Click the Edit icon to go to the PL object editing page.

Function editing page

Right-click the target item in the function list. In the menu that appears, click Edit to go to the function editing page. In the code area of the editing page, the statements that define the function are displayed. You can edit the statements. In addition, the toolbar provides the following buttons: