Help Center> Data Warehouse Service (DWS)> Tool Guide (Kuala Lumpur Region)> Data Studio - Integrated Database Development Tool> Data Studio GUI
Updated on 2022-08-16 GMT+08:00
View PDF

Data Studio GUI

This section describes the Data Studio GUI.

The Data Studio GUI contains the following:

  1. Main Menu provides basic operations of Data Studio.
  2. Toolbar contains the access to frequently used operations.
  3. SQL Terminal tab is used to execute SQL statements and functions/procedures.
  4. PL/SQL Viewer tab displays the information of functions/procedures.
  5. Editor Area is used to perform edit operations.
  6. Callstack pane displays the call stack.
  7. Breakpoints pane displays all the breakpoints that have been set.
  8. Variables pane displays variables and their values.
  9. SQL Assistant tab displays suggestion or reference for the information entered in SQL Terminal and PL/SQL Viewer.
  10. Result tab displays the result of an executed SQL statement or function/procedure.
  11. Message tab displays the process output, standard output, standard input, and standard errors.
  12. Object Browser tab displays the hierarchical tree structure of database connections and the database objects that users can access. All created schemas, except the public schemas, are grouped under Catalogs by default, and user schemas are grouped under Schemas of the corresponding database.
  13. Minimized Window Panel is used to open Callstack, Breakpoints, and Variables panes. This pane is displayed only when Callstack, Breakpoints, or Variables pane minimized or all three are minimized.
  14. Search Toolbar is used to search for objects in Object Browser tab.