All Products
Search
Document Center

:Stored scripts

更新時間:Jan 03, 2023

Log on to OceanBase Developer Center (ODC), and click the name of the target connection to go to the corresponding connection management page. Click Workspace in the top navigation bar, choose Stored Scripts from the drop-down list, and then choose a script that you previously stored in an SQL window or anonymous block window.

Overview

Image 560

After you choose the script, you can proceed to edit or run the script. If the script is an SQL script, ODC opens the script in an SQL window. If the script is an anonymous block script, ODC opens the script in an anonymous block window. In the script list, buttons with the following features are provided after each script name.

Feature

Description

Edit

Click Edit to modify the name and content of the script.

Delete

Click Delete to delete the script.

Script management

Click Settings to edit, import, download, or delete scripts.

Script management

Edit a script

Stored Scripts  / /> Script Management > Edit
  1. Log on to the ODC homepage, and click the name of the target connection to go to the corresponding database object management page. Choose Workspace > Stored Scripts.

  2. Select a script from the drop-down list of Stored Scripts, and click Edit to go to the Edit Script panel. You can also click Settings to go to the Script Management panel, select a script, and click Edit.

  3. In the Edit Script panel, modify Script Name and Script Content and click Save.

Delete a script

  1. Log on to the ODC homepage, and click the name of the target connection to go to the corresponding database object management page. Choose Workspace > Stored Scripts.

  2. Select a script from the drop-down list of Stored Scripts and click Delete to delete it.

Manage scripts

Stored Scripts  / /> Script Management
  1. Log on to the ODC homepage, and click the name of the target connection to go to the corresponding database object management page. Choose Workspace > Stored Scripts.

  2. Click Stored Scripts, and then click Settings in the drop-down list to go to the Script Management panel.

  3. In the Import Script section, click or drag files to import one or more scripts.

    Note

    • The size of a single file cannot exceed 250 MB.

    • Files suffixed with .sql, .pl, and .txt are supported.

  4. Take the following actions in the script list:

    • Click Refresh to refresh the script list.

    • Enter a script name in the search box to search for the script.

    • Click the check box Check box to select multiple scripts for batch download or deletion.

    • Click Copy Path to copy the script path.

    • Click Edit to edit the script.

    • Click Download to download the script.

    • Click Delete to delete the script.