Executing Query

1. Checking the Column

a. Open the menu on the upper right of the target entity from the top page of D-Ocean SDP and click [Query].

b. Enter “describe `${target entity name}`” in the text box.

c. Click the [Execute] button.

d. If the query is successful, the column for the target entity is displayed at the bottom of the screen.

2.Executing Query

a. Open the menu on the upper right of the target entity from the top page of D-Ocean SDP and click [Query].

b. Enter any query in the text box.

c. Select “SQL” from the drop-down list and click the [Execute] button.

d. If the query is successful, the results are displayed at the bottom of the screen.

Note :

  • Specify the prefix for the entity name in the FROM clause according to the scope .
    • My Entities: $
    • <Group>: $<group name>
    • Public: $public
  • You can delete the query in the text box by clicking the [Clear] button.
  • You can retain the results for when displaying the Query screen again by selecting the [Keep query result] check box.