A trigger is a special type of stored procedure. You cannot call it explicitly. Instead, it is activated by an event. A trigger monitors a specific condition and initiates an action.
In OceanBase Developer Center (ODC), open a connection in Oracle mode. In the navigation pane on the left, click the Triggers label to view the list of triggers. Click the + button in the upper-right corner of the list to open the Create Trigger page. You can also double-click a trigger name in the list to open the trigger management page, which displays the trigger's basic information and code.
OceanBase Database versions V2.2.20 and later support creating trigger objects in Oracle mode. This feature is not available in MySQL mode.
This chapter covers the following operations for triggers in ODC: