What's New
Function Overview
Product Bulletin
- Product Notice
- Version Support Notes
Service Overview
- GaussDB(DWS) Infographics
- What Is GaussDB(DWS)?
- Data Warehouse Types
- Data Warehouse Flavors
- Advantages
- Application Scenarios
- Functions
- Concepts
- Related Services
- Security
- GaussDB(DWS) Permissions Management
- GaussDB(DWS) Access
- Restrictions
- Technical Support
- Service Quotas
- GaussDB(DWS) Technical Specifications
Billing
- GaussDB(DWS) Billing Overview
- Billing Modes
- Item
- Billing Examples
- Billing Mode Change
- Renewal
  - Overview
  - Manual Renewal
- Bills
- Arrears
- Stopping Billing
- Cost Management
- Billing FAQs
Getting Started
- Checkpoint Vehicle Analysis
- Supply Chain Requirement Analysis of a Company
- Operations Status Analysis of a Retail Department Store
- Creating a Time Series Table
- Best Practices of Hot and Cold Data Management
- Best Practices for Automatic Partition Management
- Creating a Cluster and Connecting to It
- Using CDM to Migrate MySQL Data to the GaussDB(DWS) Cluster
- Using DLI Flink Jobs to Write Kafka Data to GaussDB(DWS) in Real Time
- Basic SQL Operations
- Database Quick Start
- Getting Started with Common Practices
User Guide
- Using GaussDB(DWS)
- Preparations
- Creating a GaussDB(DWS) Cluster
- Connecting to a GaussDB(DWS) Cluster
- Creating a GaussDB(DWS) Database and User
- Migrating Service Data to a GaussDB(DWS) Cluster
  - Migrating Data to a GaussDB(DWS) Cluster Using GDS-Kafka
  - Data Source Management
- GaussDB(DWS) Cluster Data Security and Encryption
- GaussDB(DWS) Cluster Management
- GaussDB(DWS) Cluster O&M
Best Practices
- Import and Export
- Data Migration
- Data Analytics
- Decoupled Storage and Compute
  - DWS 3.0 Decoupled Storage and Compute Usage Suggestions and Performance Optimization
- Data Development
- Database Management
- Performance Tuning
  - Optimizing Table Structure Design to Enhance GaussDB(DWS) Query Performance
  - Analyzing SQL Statements That Are Being Executed to Handle GaussDB(DWS) Performance Issues
- Cluster Management
  - Binding Different Resource Pools to Two Types of Jobs to Balance Load for GaussDB(DWS)
  - Scaling Options for GaussDB(DWS) with a Coupled Storage-Compute Architecture
Data Migration and Synchronization
- Data Migration to GaussDB(DWS)
- Importing Data
- Full Database Migration
  - Using CDM to Migrate Data to GaussDB(DWS)
  - Using DSC to Migrate SQL Scripts
- Real-time Import
  - Using DRS to Import Data to GaussDB(DWS)
  - Real-time Data Import From Kafka GaussDB(DWS)
- Metadata Migration
  - Using gs_dump and gs_dumpall to Export Metadata
  - Using gs_restore to Import Data
- Exporting Data
- Other Operations
Developer Guide
- Standard data warehouse (9.1.0.x)
- Standard data warehouse (8.1.3.x)
- Hybrid Data Warehouse (9.1.0.x）
- Hybrid Data Warehouse (8.1.3.x）
- Historical Versions
SQL Syntax Reference
- SQL Syntax Reference (9.1.0.x)
- SQL Syntax Reference (8.1.3.x)
- Historical Versions
Performance Tuning
- Overview of Query Performance Optimization
- Query Execution Process
- SQL Execution Plan
- SQL Optimization Guide
- Optimization Cases
- SQL Execution Troubleshooting
- query_band Load Identification
- Common Performance Parameter Optimization Design
Tool Guide
- Overview
- Downloading Related Tools
- gsql
- Data Studio
- GDS
- DSC
- DataCheck
- DWS-Connector
- Server Tool
API Reference
- Before You Start
- API Overview
- Calling APIs
- Getting Started
- API Description
- Application Cases
  - Using Postman to Call the API for Creating a Cluster
  - Using Postman to Call the API for Creating a Snapshot
- Introduction
- Appendix
SDK Reference
- SDK Overview
FAQs
- Top FAQs
- Product Consulting
- Database Connections
- Data Migration
- Database Usage
- Cluster Management
- Account Permissions
- Database Performance
- Backup and Restoration
  1. Why Does It Take a Long Time to Create an Automated Snapshot in GaussDB(DWS)?
  2. Does a GaussDB(DWS) Snapshot Have the Same Function as an EVS Snapshot?
Troubleshooting
- Database Connections
- JDBC/ODBC
- Data Import and Export
- Database Parameter Modification
- Account/Permission/Password
- Cluster Performance
- Cluster Exceptions
  - The Disk Usage Alarm Is Frequently Generated
- Database Use
Videos
Performance White Paper
- Overview
- Test Result
  - TPC-H Single Query Test
  - TPC-DS Single Query Test
- Test Methods
- Appendixes
  - TPC-H Test Sets
  - TPC-DS Test Sets
Technical White Paper
- GaussDB(DWS)
- Platforms and Technical Specifications Supported by GaussDB(DWS)
  - Technical Specifications
- GaussDB(DWS) Core Technologies
- GaussDB(DWS) Tools
  - Client Tools
  - Database Monitoring Tool
- External APIs
Error Code Reference
- 8.2.0 and earlier versions
  - Management Console Error Code
  - Data Warehouse Service Error Codes
- 8.2.1 or later versions
Glossary
More Documents
- User Guide
- API Reference (ME-Abu Dhabi Region)
- Developer Guide (ME-Abu Dhabi Region)
- SQL Syntax Reference (ME-Abu Dhabi Region)
- Tool Guide (ME-Abu Dhabi Region)
- Error Code Reference (ME-Abu Dhabi Region)
  - Management Console Error Code
- User Guide (Paris Region)
- API Reference (Paris Region)
- Developer Guide (Paris Region)
- SQL Syntax Reference (Paris Region)
- Tool Guide (Paris Region)
- Error Code Reference (Paris Region)
  - Management Console Error Code
- User Guide (Kuala Lumpur Region)
- API Reference (Kuala Lumpur Region)
- Developer Guide (Kuala Lumpur Region)
- SQL Syntax Reference (Kuala Lumpur Region)
- Tool Guide (Kuala Lumpur Region)
- Error Code Reference (Kuala Lumpur Region)
  - Management Console Error Code
General Reference
- Glossary
- Service Level Agreement
- White Papers
- Endpoints
- Permissions

On this page

Auto Commit
Execute SQL Queries
Multi-Column Sort
Backuping Unsaved Queries/Functions/Procedures
Error Locator
Search in PL/SQL Viewer or SQL Terminal
Go to Line in PL/SQL Viewer or SQL Terminal
Comment/Uncomment
Indent/Un-indent Lines
Insert Space
Execute Multiple Functions/Procedures or Queries
Rename SQL Terminal
SQL Assistant
Using Templates

Show all

Help Center/ GaussDB(DWS)/ Tool Guide/ Data Studio/ SQL Terminal Management/ Working with SQL Terminals

Working with SQL Terminals

Updated on 2025-01-09 GMT+08:00

View PDF

In SQL Terminal, you can

Automatically Commit a Transaction
Execute SQL Queries
Multi-Column Sort
Backuping Unsaved Queries/Functions/Procedures
Error Locator
Search in PL/SQL Viewer or SQL Terminal
Go to Line in PL/SQL Viewer or SQL Terminal
Comment/Uncomment
Indent/Un-indent Lines
Insert Space
Execute Multiple Functions/Procedures or Queries
Rename SQL Terminal
SQL Assistant
Using Templates

Auto Commit

The Auto Commit option can be switched on or off based on the Preferences settings. Refer to Table 1 for more details.

If Auto Commit option is enabled, Commit and Rollback buttons are disabled. Transactions are committed automatically.
If Auto Commit option is disabled, Commit and Rollback buttons are enabled. You can use the buttons manually to commit or revert the changes.
NOTE:
- For OLAP, the server will open a transaction for all SQL statements, such as select, explain select, and set parameter.
- For OLTP, the server will open a transaction for only DML statements, such as INSERT, UPDATE, and DELETE.

Reuse Connection

It enables the user to choose the same SQL terminal connection or new connection for the result set. The selection affects the record visibility due to the isolation levels defined in the database server.

When Reuse Connection is ON, terminal connection will be used for data manipulation and refresh of the result window.

For some data base temp tables that are created or used by the terminal can be edited in the result window.

When Reuse Connection is OFF, new connection will be used for data manipulation and refresh of the result window.

For some databases, the temporary tables can be edited in the Result tab.

: displayed when Reuse Connection is set to ON

: displayed when Reuse Connection is set to OFF

: displayed when Reuse Connection is disabled

Perform the following steps to set Reuse Connection to OFF:

Click on the SQL Terminal toolbar.

Reuse Connection is disabled for the terminal.
NOTE:
- The Reuse Connection function is enabled by default. You can disable it as required. If you enable Auto Commit, the system automatically enables the Reuse Connection function.
- If you disable Auto Commit, the system automatically disables the Reuse Connection function. However, this function is still displayed as Enabled on the GUI, and the status cannot be modified.

Refer to Table 1 for more details about Auto Commit and Reuse Connection.

Execute SQL Queries

Perform the following steps to execute a function/procedure or SQL query.

Enter a function/procedure(s) or SQL query(s) in the SQL Terminal tab and click Click to enlarge in the SQL Terminal tab, or press Ctrl+Enter, or choose Run > Compile/Execute Statement from the main menu.

Alternatively, you can right-click in the SQL Terminal tab and select Execute Statement.

NOTE:

You can check the status bar to view the status of a query being executed.

The Result tab displays the results after executing the function/procedure(s) or SQL queries along with the query statement executed.

If the connection is lost during execution and the database is still connected in Object Browser, then Connection Error dialog box is displayed:

Reconnect - The connection is reestablished.
Reconnect and Execute - With Auto commit on, execution will continue from failure statement. With Auto commit off, execution will continue from position of cursor.
Cancel - Disconnects database in Object Browser.

Failure to reconnect after three attempts will disconnect the database in Object Browser. Connect to the database in Object Browser and retry execution.

NOTE:

For long running queries, result set can be edited only after the complete results are fetched.
Editing of query results are only allowed in following scenarios:
- Selected targets are from a single table
- Either select all columns or subset of columns [No aliases, aggregate functions, expressions on columns]
- All WHERE condition
- All ORDER BY clause
- On regular, partition, and temporary tables.
Committing an empty row assigns Null to all columns.
Only result set of queries executed on tables available in Object Browser is editable.
Editing of query results is allowed only for queries executed in SQL Terminal.

The column width definition can be set using Settings > Preferences option. Refer to Table 1 to set this parameter.

Column Reorder

Column reordering can be performed by clicking and dragging the selected column header to the desired position.

Multi-Column Sort

This feature allows the user to sort table data of some pages by multiple columns. In addition, you can set the priority of columns for sorting.

The feature is available for the following pages:

Result Set Tab
Edit Table Data Window
View Table Data Window
Batch Drop Result Window

Follow the steps below to access Multi-column sort:

Click in the toolbar.

Multi-Column Sort pop-up is displayed.
Click Add Column. Choose the column to be sorted from the drop-down list.
Select the required sort order.
Click Apply.

Multi-sort pop up has following elements:

**Table 1** Elements of multi-column pop-up:
Attribute Name	UI Element Type	Description/Action
Priority	Read only text field	Shows column priority in multi sort.
Column Name	Combo field having all column names of the table as its value set	Column name of the column added for sorting.
Data Type	Read only text field	Shows data type of the column selected.
Sort Order	Combo field having values {sort_ascending, sort_descending}	Sort order of the column.
Add Column	Button	Adds new row to multi-sort table.
Delete Column	Button	Deletes selected column from multi-sort table.
Up	Button	Moves selected column up by 1 step, thus changing sort priority.
Down	Button	Moves selected column down by 1 step, this changing sort priority.
Apply	Button	Apply prepared sort configuration.

NOTE:

Except following data types, all the other data types will be sorted by their string value (Alphabetical order):

TINYINT, SMALLINT, INTEGER, BIGINT, FLOAT, REAL, DOUBLE, NUMERIC, BIT, BOOLEAN, DATE, TIME, TIME_WITH_TIMEZONE, TIMESTAMP, TIMESTAMP_WITH_TIMEZONE.

Elements of Multi-Column Pop-up:

**Table 2** Icons of multi-column Pop-up
Icon	Description	Action
	Not Sorted	This icon in column header indicates that the column is not sorted. You can click this icon to sort the column in ascending order. Alternatively, use Alt+Click to select the column header.
	Ascending Sort	This icon in column header indicates that the column is sorted in ascending order. If you click this icon, the column will be sorted in descending order. Alternatively, use Alt+Click to select the column header.
	Descending Sort	This icon in column header indicates that the column is sorted in descending order. You can click this icon to cancel the column sorting. Alternatively, use Alt+Click to select the column header.

Icons for the sort priority are as follows:

Click to enlarge : Icon with three dots indicates the highest priority.

Click to enlarge : Icon with two dots indicates the second highest priority.

: Icon with one dot indicates the lowest priority.

**Table 3** Toolbar Menus
Toolbar Name	Description
Copy	This button is used to copy selected content from result window to clipboard. Shortcut key - Ctrl+C.
Advanced Copy	This button is used to copy content from result window to clipboard. Results can be copied to include column header. Refer to Table 1 to set this preference. The shortcut key is Ctrl+Shift+C.
Export all data	This button is used to export all data in Excel (xlsx/xls), CSV, text, or binary format. For details, see Exporting Table Data. NOTE: The columns involved in the query are automatically populated in the Selected Columns area. The Available Columns area is empty. To export the query results, the query is re-executed using a new connection. The exported results may differ from the data in the results tab. Disabled for explain/analyze queries. To export explain/analyze queries use the Export current page data option.
Export current page data	This button is used to export current page data in Excel (xlsx/xls) or CSV format.
Paste	This button is used to paste copied information.
Add	This button is used to add a row to the result set.
Delete	This button is used to delete a row from the result set.
Save	This button is used to save the changes made in the result set.
Rollback	This button is used to roll back the changes made to the result set.
Refresh	This button is used to refresh information in the result set. If multiple result sets are open for the same table, then changes made to one result set will reflect on the other post refresh. Similarly if the same table is edited, then the result set will be updated post refresh.
Clear Unique Key selection	This button is used to clear the previous unique key selection.
Show/Hide Query bar	This button is used to display/hide the query executed for that particular result set. This is a toggle button.
Show/Hide Search bar	This button is used to display/hide the search text field. This is a toggle button.
Encoding	Whether you can configure this field depends on the settings in Preferences > Result Management > Query Results > Result Data Encoding. In this drop-down list, you can select the appropriate code to view the data accurately. By default, the text is encoded using UTF-8. Refer to Table 1 to set the encoding preference. NOTE: Data editing except for data insertion is restricted once the default encoding is modified.
Multi Sort	This button brings up multi-sort pop up.
Clear Sort	This button is used to reset all the sorted column.

Icons in Search field:

Icon Name	Icon	Description
Search		This icon is used to search the result set based on the criteria defined. The text is case-insensitive.
Clear Search Text		This icon is used to clear the search text entered in the search field.

Right-click options in the Result window:

Option	Description
Close	Closes only the active result window.
Close Others	Closes all other result windows except for the active result window.
Close Tabs to the Right	Closes only the right active result window.
Close All	Closes all result windows including the active result window.
Detach	Detach from current active result window.

Status information displayed in the Result window:

Query Submit Time - Provides the query submitted time.
Number of rows fetched with execution time is displayed. The default number of rows is displayed. If there are additional rows to be fetched, then it will be denoted with the word "more". You can scroll to the bottom of the table to fetch and display all rows.
NOTICE:

When viewing table data, Data Studio automatically adjusts the column widths for a good table view. Users can resize the columns as needed. If the text length exceeds the column width and you adjust the column width, Data Studio may fail to respond.

NOTE:

Each time a query is run in SQL Terminal tab, a new result window opens. To view the results in the new window, you must select the newly opened window.
Set the focusOnFirstResult configuration parameter to false to automatically set focus to the newly opened Result window. For details, see Configuring Data Studio.
Each row, column and selected cells can be copied from the result set.
Export all data operation will be successful even after the connection is removed.
If the text of a column contains spaces, word wrapping is applied to fit the column width. Word wrapping is not applied to columns without spaces.
Select part of cell content and press Ctrl+C or click to copy selected text from a cell.
The size of the column is determined by the maximum content length column.
You can save preference to define:
- Number of records to be fetched
- Column width
- Copy option from result set
  For details, see Table 1.
If any column of resultset tab has Lock Image icon in it, then values are not editable.

Backuping Unsaved Queries/Functions/Procedures

Data Studio creates back up of unsaved data in SQL Terminal and PL/SQL Viewer periodically based on the time interval defined in the Preferences tab. The data can be encrypted and saved based on Preference settings. Refer to Table 1 to turn on/off backup, define time interval to save the data, and encrypt the saved data.

Unsaved changes of each SQL Terminal/PL/SQL Viewer are taken as backup and stored in DataStudio\UserData\<user name>\Autosave folder. Backup files saved before unexpected shutdown of Data Studio will be available at next login.

In case there is unsaved data in SQL Terminal/PL/SQL Viewer, during graceful exit, Data Studio will wait for backup to complete before closing.

Error Locator

During execution of query/function/procedure in case of an error the error locator message is displayed.

Yes - Click Yes to continue with the execution.

No - Click No to stop the execution.

You can select Do not display other errors that occur during the execution to hide the error messages and proceed with the current SQL query.

Line number and position of error displays in Messages tab. The corresponding line number is marked with icon along with red underline at the position of the error in the Terminal/PL/SQL Viewer. Hovering over displays the error message. For details about why the line number does not match the error detail, see FAQs.

NOTE:

If the query/function/procedure is modified while execution is in progress, then error locator may not display the correct line and position number.

Search in PL/SQL Viewer or SQL Terminal

Follow the steps below to search in PL/SQL Viewer or SQL Terminal:

F3 key is used to search next word and Shift+F3 key is used to search previous word. These shortcut keys will be enabled only after Ctrl+F is used to search a text. These keys will be active with the current search word until a new word is searched. The value searched using Ctrl+F and F3/Shift+F3 will be applicable only for the current instance.

Choose Edit > Find and Replace from the main menu.

Alternatively press Ctrl+F.

Find and Replace dialog box is displayed.
Enter the text to be searched for in the Find what field, and click the Find Next button.

The desired text is highlighted.

F3 and Shift+F3 key will now be enabled for forward and backward search.

NOTE:

Select Wrap around option to continue the search after reaching the last line in the SQL queries or PL/SQL statements.

Go to Line in PL/SQL Viewer or SQL Terminal

Go to line option is used to skip to a specific line in the terminal.

Follow the steps below to go to a line in PL/SQL Viewer or SQL Terminal:

Choose Edit > Go To Line from the main menu or press Ctrl+G.

The Go To Line dialog box is displayed.
Enter the desired number in the Enter the line number field, and then click the OK button.
The cursor moves to the beginning of the line entered in the Go to Line dialog box.
NOTE:
The following inputs are invalid for the Enter line number field:
- Non-numeric value
- Special characters
- Line number entered does not exist in the editor.
- More than 10 digits is entered.

Comment/Uncomment

Comment/uncomment option is used to comment/uncomment lines or block of lines.

Follow the steps below to comment/uncomment lines in PL/SQL Viewer or SQL Terminal:

Select the lines to comment/uncomment.
Choose Edit option. Choose Comment/Uncomment Lines from the main menu.

Alternatively, press Ctrl+/ or right-click a line and select Comment/Uncomment Lines.

Follow the steps below to comment/uncomment block of lines/content in PL/SQL Viewer or SQL Terminal:

Select the lines/content to comment/uncomment.
Choose Edit option. Choose Comment/Uncomment Block from the main menu.

Alternatively, press Ctrl+Shift+/ or right-click a line or the entire block and select Comment/Uncomment Block.

Indent/Un-indent Lines

The indent/un-indent option is used to shift lines as per the indent size defined in the Preferences tab.

Follow the steps to indent lines in PL/SQL Viewer or SQL Terminal:

Select the lines to indent.
Press Tab or click .

Shift the selected line as per the indent size defined in the Preferences tab. For details about modifying the indent size, see Table 1.

Follow the steps to un-indent lines in PL/SQL Viewer or SQL Terminal:

Select the lines to un-indent.
Press Shift+Tab or click .

Move the selected lines according to the indent size defined in Preferences. For details about modifying the indent size, see Table 1.

NOTE:

Only selected lines that have available tab space will be un-indented. For example, if multiple lines are selected, and one of the selected lines starts at position 1, then pressing Shift+Tab will un-indent all the lines except for the one starting at position 1.

Insert Space

The Insert Space option is used to replace a tab with spaces based on the indent size defined in the Preferences tab.

Follow the steps below to replace a tab with spaces in PL/SQL Viewer or SQL Terminal:

Select the lines to replace tab with spaces.
Press Tab or Shift+Tab.

Replaces the tab with spaces as per the indent size defined in the Preferences tab. For details about modifying the indent size, see Table 1.

Execute Multiple Functions/Procedures or Queries

Follow the steps below to execute multiple functions/procedures:

Insert a forward slash (/) in a new line after the function/procedure in the SQL Terminal.

Add the new function/procedure in the next line.

Click to enlarge

Follow the steps below to execute multiple SQL queries:

Enter multiple SQL queries in the SQL Terminal tab as follows:
Click in the SQL Terminal tab, or press Ctrl+Enter, or choose Run > Compile/Execute Statement from the main menu.
NOTE:
- If the queries are not selected for execution, then only the query in the line where cursor is placed will be executed.
- If the cursor is placed next to an empty line, then the next available query statement will be executed.
- If the cursor is placed at the last line which is blank, then no query will be executed.
- If a single query is written in multiples lines and the cursor is placed at any line of the query, then that query is executed. Queries are separated using semicolon (;).

Do as follow to execute an SQL query after a function/procedure:

Insert a forward slash (/) in a new line after the function/procedure and click Click to enlarge in the SQL Terminal tab.

Do as follow to execute PL/SQL statements and SQL queries on different connections:

In the toolbar, select the required connection from the connection profiles drop-down list and click Click to enlarge in the SQL Terminal tab.

Rename SQL Terminal

Follow the steps below to rename SQL Terminal:

In the SQL Terminal tab right-click and select Rename Terminal.

A Rename Terminal dialog box is displayed prompting you to provide the new name for the Terminal.
Enter the new name and select OK to rename the Terminal.
NOTE:
- Terminal name follows Windows file naming convention.
- Rename Terminal allows a maximum of 150 characters.
- Restore option is not available to revert to the default name. You must manually rename the Terminal to default name.
- Tool tip of the renamed Terminal will display the old name.

SQL Assistant

The SQL Assistant tool provides suggestion or reference for the information entered in SQL Terminal and PL/SQL Viewer. Follow the steps to open SQL Assistant:

When Data Studio is launched SQL Assistant panel displays with related syntax topics. As you type a query in the SQL Terminal topics related to the query is displayed. It also provides precautions, examples, syntax, function, and parameter description. Select the text and use the right-click option to copy selected information or copy and paste to SQL Terminal.

NOTE:

Choose Settings > Preferences > Environment > Session Setting. In the SQL Assistant area, enable or disable the SQL Assistant function permanently. By default, the SQL Assistant function is enabled permanently.
After the SQL Assistant function is enabled, you can click the SQL Assistant icon () on the toolbar to open the SQL Assistant window. If the SQL Assistant icon is gray after the SQL Assistant is enabled, the SQL Assistant is invalid.

Using Templates

Data Studio provides an option to insert frequently used SQL statements in SQL Terminal or PL/SQL Viewer using the Templates option. Some of the commonly used SQL statements are saved for ease of use. You can create, modify existing templates or remove templates. For details about how to add, delete, and create a template, see Table 1.

The following table lists the default templates:

Name	Description
df	delete from
is	insert into
o	order by
s*	select from
sc	select row count
sf	select from
sl	select

Follow the steps to use the Templates option:

Enter the name of the template in SQL Terminal/PL/SQL Viewer.

Press Alt+Ctrl+Space.

A list of saved template information is displayed. The list displayed is based on the following criteria:

Exact Match	Display List
On	Displays all entries that match the input text case. Example: Entering "SF" in SQL Terminal/PL/SQL Viewer displays all entries that start with "SF".
Off	Displays all entries that match the input irrespective of the text case. Example: Entering "SF" in SQL Terminal/PL/SQL Viewer displays all entries that start with "SF", "Sf", "sF", or "sf".

Exact Match

Display List

Displays all entries that match the input text case.

Example: Entering "SF" in SQL Terminal/PL/SQL Viewer displays all entries that start with "SF".

Off

Displays all entries that match the input irrespective of the text case.

Example: Entering "SF" in SQL Terminal/PL/SQL Viewer displays all entries that start with "SF", "Sf", "sF", or "sf".

Text Selection/Cursor Location	Display List
A text is selected and the shortcut key is used	Displays entries that match the text before the selection to the nearest space or new line character.
No text selected and the shortcut key is used	Displays entries that match the text before the cursor to the nearest space or new line character.

NOTE:

Using the shortcut key without entering text in SQL Terminal/PL/SQL Viewer displays all entries in the Templates.
If the text entered in SQL Terminal/PL/SQL Viewer has only a single match, then it will be replaced directly in the SQL Terminal/PL/SQL Viewer without listing them out.

Parent topic: SQL Terminal Management

Previous topic: Viewing the Query Execution Plan and Cost Graphically

Next topic: Exporting Query Results

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Chatbot