Manage functions |V3.2.0|OceanBase Developer Center| docs|Distributed Database

Manage functions

Last Updated：2023-06-25 03:26:45 Updated

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, where you can find the table describing the management options.

Management actions

Right-click the target object in the structure tree. A shortcut menu appears, displaying some management options provided by ODC for you to conveniently manage the target object.

The following table describes the management options.

Option	Description
View	Click this option to go to the function management page , where you can view comprehensive information such as the basic information, parameters, and code of the function.
Create	Click this option to go to the Create Function page, where you can create a function as prompted.
Edit	Click this option to go to the function management page , which displays the statements that define the function and where you can continue to edit the function.
Compile	Click this option to compile the function.
Debug	Click this option to go to the debugging page , where you can debug the function. PL object debugging is supported only when OBServer V2.2.70, V3.0.00, or a later version is connected.
Run	Click this option to execute the function.
Delete	Click this option to delete the function.
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.

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:

Basic Info : displays information about the function, such as Function Name , Return Type , and Creator .
Parameter : displays parameter information, such as Name , Order , Mode , Data Type , and Default Value .
Code : displays the script that defines the function and provides the Edit and Find buttons. You can click Edit to go to the function 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:

Button	Description
Confirm Modification	Click this button to apply the current modification.
Compile	Click this button to compile the statements on the current page.
Run	Click this button to execute the statements in the code area.
Debug	Click this button to go to the debugging page, where you can debug the PL object in the code area.
Format	Click this button to apply formatting, such as indentation, line break, and keyword highlighting, to the selected SQL statements or all the SQL statements in the current SQL window.
Find and Replace	You can specify search criteria in the search box to find specific content in the script and enter other content in the replacement box to replace the content found.
Undo	Click this button to undo the last operation.
Redo	Click this button to reverse an Undo operation.
Case Sensitivity	The system supports three configurations: All Caps , All Lowercase , and Capitalize the first letter . Click this button to convert the selected statements in the script to the corresponding capitalization format.
Indent	The Add Indents and Delete Indent options are provided, to allow you to add indents to or delete indents from the selected statements in the script.
Comment	The Add Comments and Delete Comment options are provided, which respectively allow you to convert the selected statements in the script to comments and convert comments to SQL statements.