Home
SQL Select online help Prev Page Prev Page
Introduction
About SQL Select
Version history
Supported database engines
Contact us
Using SQL Select
Connecting to a database server
Conecting to databases directly without client libraries installed
Connecting to an Oracle database
The SQL workspace
SQL editor
Query selection
Data sets
Locking data sets
Exporting data sets
Export to text file
Export to Excel
Export to SQLite

Query selection

SQL Select's editor uses an intuitive command selection method to aid you in quickly running SQL commands. You can keep multiple queries in the editor, you can use blank rows as delimiters, and you can run queries without having to explicitly select them.

To see how SQL Select determines which command to run, how a look at the following example:

command01a  
 
When the caret is placed anywhere on lines 1 to 5, and you click execute (Execute), SQL Select will select and run the text on lines 1 to 4.

When the caret is placed anywhere on lines 6 to 7, and you click execute (Execute), SQL Select will select and run the text on line 6.

When the caret is placed anywhere on lines 8 to 14, and you click execute (Execute), SQL Select will select and run the text on lines 8 to 12.