Working with SQL Queries

Like most of SQL query tools, the Database Tour does not execute your database queries directly. It makes some checks and then passes the queries for execution to the core application intended for doing this: your database server or database engine (FD, ADO etc.). Therefore, SQL queries must be written using rules defined for currently opened database: for example, if you open Oracle database, write your query following Oracle database rules etc. If you have questions about the correct SQL syntax in a particular database, please refer to the documentation for the that database.

Below are topics which describe the common technique and Database Tour specific capabilities which helps you to build your queries and get their results.

SQL Query Windows

SQL Editor

Query Execution

Server Output

Running Scripts with Multiple SQL Statements

Asynchronous SQL Query Execution

Queries with Parameters and Macros

Using Master Source

Querying Several Databases at Once

See also