Help Center> Data Warehouse Service> Tool Guide> Data Studio - Integrated Database Development Tool> SQL Terminal> Opening SQL Terminals
View PDF

Opening SQL Terminals

You can open multiple SQL Terminal tabs in Data Studio. You can use this feature to work with SQL queries when the current SQL Terminal is executing a query.

Follow the steps below to open a new SQL terminal:

You can also open multiple SQL terminals on different connection profiles.

  1. In the Object Browser pane, right-click the selected database and select Open Terminal or click on the toolbar or the Ctrl+T shortcut key to open new SQL terminal.

    The new SQL Terminal tab is displayed.

  • Data Studio supports a maximum of 100 SQL terminals and tabs in total. Each SQL Terminal will have multiple Result and one Messages tab based on the number of times a query is executed. If the connection with the database is lost, then the corresponding SQL Terminals are not disabled.
  • Restoring individual SQL terminal or tabs is not possible. The restoration operation restores the complete set of minimized SQL terminals and tabs.
  • Data Studio resets the numbering counter of SQL terminal after all terminals are closed.
  • Data Studio resets the numbering counter of Resultset after all the tabs are closed.
  • Data Studio resets the numbering counter for show DDL Tablespace, show DDL Users/Roles, Batch Drop tab, Result tab and Execution Plan tab.

Errors and warnings are displayed which do not have corresponding results in the status bar. Results of successful executions are displayed in the Result tab.

Follow the steps below to open a new SQL terminal on a different connection profile:

  1. On the toolbar, select the required connection from the connection profile drop-down list.
  2. In the Object Browser pane, right-click the selected database in the connection profile and select Open Terminal or click on the toolbar. The new SQL Terminal tab is displayed.

    The new SQL Terminal tab is named as <database_name>@<connection_profile>(<tab_number>). For example, postgres@IDG_1(2). The tab number is updated for each new SQL Terminal tab of the connection profile.

Managing Right Click Option On Result Window

This feature allows copying, exporting cell data to excel files and generate SQL files of queries as well.

The Right click on the result window after the result of the SQL query is shown. Right click menu is displayed as follows:

Follow the steps for to include the row number and column header information in Result Set:

  1. Click Settings on the Menu bar of Data Studio.
  2. Select Preferences.
  3. Expand Result Management and select Query Results.
  4. Under Result Advanced Copy option check Include column header and Include row number boxes.

Feature description of the menu is as follows:

Table 1 Right click menu

Menu Option

Sub Menu

Description

Copy Data

Copy

Copies the selected cell data.

Advanced Copy

Copies the selected cell data with row number and column header as per the preference setting.

Copy to Excel

Copy as xls

Exports the selected cell data in xls format. Maximum 64,000 Rows and 256 columns can be exported.

Copy as xlsx

Exports the selected cell data in xlsx format. Maximum 1 million Rows can be exported.

Export

Current Page

Exports the table data of the current page.

All Pages

Exports the entire table content.

Generate SQL

Selected Line

Generates the SQL file of the selected data in logical insert statement.

Current Page

Generates a SQL file of the current page data in logical insert statement.

All Pages

Generates a SQL file of entire table data in logical insert statement.

Set Null

-

Sets a cell data to null.

Search

-

Searches the selected cell data and displays all the data that matches the search condition.

Generated SQLs are not valid for result sets derived from queries with JOINs, Expressions, Views, Set operators, Aggregate functions, GROUP By clause and column aliases.

Viewing the Result Tab in Text Mode

This new feature in Data Studio enables you to view the data in text mode in resultset tab.

Apart from the grid view, the text mode view provides you with two features: copying and searching.

  1. Click the icon to obtain the result in text mode.

Selecting multiple cell data and searching may show some incorrect results in text mode as all the information is copied in plain text to the search window.

Displaying Execution Progress Bar

When a query is being executed on the SQL terminal, a progress bar is displayed indicating the running time dynamically. The progress bar disappears as the query execution finishes. The total duration of the query is displayed alongside the progress bar.

An option to cancel the query execution is available alongside the progress bar if required.

Refer to the following image:

  • The Cancel button now has been removed from the toolbar.
  • Execution Progress Bar is also shown in compiling/debugging of function/procedures in PL/SQL editor.
  • The time format shown in the progress bar will be: w hrs x min y sec z ms.
  • For batch execution in SQL Terminal, the progress bar is shown with total elapsed time on completion.

Debugging Time Consumption

Data Studio displays a status bar during debugging, that shows the Last Operation Time consumed for executing statement in each debugging operation and also the Total Debug Time.

While debugging, based on each operation performed, the Last Operation Time and Total Debug Time provided in terminal status bar gets updated. Total Debug Time is the cumulative sum of Last Operation Time.

This provides an easy way to find out huge time consuming statement of the debugged object.

Refer to the following picture:

  • Debugging is applicable for both functions and procedures.
  • It is only applicable for OLAP.
Parent topic: SQL Terminal