Using the Query Analyzer

Click here for a diagram of the toolbar button functions

Toolbar Functionality 

The toolbar allows you to create a new query, open scripts, save scripts, save results, copy content, cut content, paste content, undo, redo, find, replace, change case, parse, execute, execute current, execute edit, execute explain, stop execution, auto-commit, commit, rollback, reconnect, enable auto-completion, refresh the auto schema, run a parameterized script, and set the maximum results displayed.

You can change the database you are analyzing in the drop-down menu above the edit window.

Scripts and SQL Statement Separators: Only use GO or /

To use all of the Query Analyzer functionalities you need to separate your SQL statements by using ¨GO¨ or ¨/¨. This allows Aqua Data Studio to quickly identify which statement you are working on so that it may intelligently provide Auto-Completion, Describe, SQL Template, and Execute as a script on the current statement. If you omit this, Aqua Data Studio will not perform effectively.

DO NOT separate your statements with a semicolon ";" 

The reason Aqua Data Studio does not use ";" as a separator for SQL statements is because PL/SQL and T-SQL may contain ";". Therefore, it keeps the parser fast and simple for Auto-Completion. If you try to use it as a separator Aqua Data Studio will not be able to identify your current statement and will give you the impression that Auto-Completion and other features do not work. Executing as a script will also generate errors from the RDBMS, unabling it to understand your statement.

You MUST separate your SQL Statements 

If you do not separate your statements, Aqua Data Studio will not be able to identify your current statement or separate them for script execution.                

Auto-Completion

The Query Analyzer provides auto-completion popups for tables, views, synonyms, and their columns. It determines when to popup tables or columns according to the cursor position in the SQL statement at the time of popup. Although the query window will intelligently decide when to popup options, you may activate the auto-completion feature with the CTRL+Space shortcut.

Abbreviation Support 

User-defined abbreviations, created within the SQL Editor Options, work as customizable auto-completion strings. An entire block of SQL commands can be inserted with a few keystrokes. There is a selection of key combinations to trigger the expansion of an abbreviation. Abbreviations are set within File > Options > Editors > SQL Editor > Abbreviations.

Encoding SQL Scripts & Query Results

Aqua Data Studio supports SQL Scripts encoded in different encoding formats. When opening a SQL Script, select the ’File Type’ with the appropriate encoding. Aqua Data Studio also allows saving result sets into different encoding types.

Unicode/Character sets - ADS supports Unicode and International character sets, however, you have to verify you are using the international JRE and that ADS is using a font that supports the character set you are using. The bundled JRE which comes with ADS is the International version, but if you are using your own check if it supports International character sets. The default font used by ADS does not support all character sets, so if you need support for Japanese, Chinese and other languages you might need to change your font by selecting File > Options > General >Appearance and select an appropriate font.