Its ability to examine graphically allows you to extract the definition of the structure of all objects in the schema and to write the SQL DDL and DML (example: CREATE, ALTER, DROP, SELECT, INSERT, UPDATE OR DELETE) syntax for the objects of the Database schemas (including Grids, Views, Triggers, Saved Procedures, and Functions). Date Table EditorĪ powerful Data Table Editor gives you the ability to modify and save the results graphically. Simply typing a SELECT table statement in Search Analyzer and hitting the "Run Correction" button opens a separate window with the result, which you can review and save. You can also browse a table in the schematic finder and select Edit Table from the menu bar to edit the first thousand files. The search analyzer lets users generate visual explain plans with or without executing the SQL statements. 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.These plans can be displayed in a tree table or diagram. 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. 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. Aqua Data Studio also allows saving result sets into different encoding types. When opening a SQL Script, select the ’File Type’ with the appropriate encoding. Īqua Data Studio supports SQL Scripts encoded in different encoding formats. Abbreviations are set within File > Options > Editors > SQL Editor > Abbreviations. There is a selection of key combinations to trigger the expansion of an abbreviation. An entire block of SQL commands can be inserted with a few keystrokes. User-defined abbreviations, created within the SQL Editor Options, work as customizable auto-completion strings. Although the query window will intelligently decide when to popup options, you may activate the auto-completion feature with the CTRL+Space shortcut. It determines when to popup tables or columns according to the cursor position in the SQL statement at the time of popup. The Query Analyzer provides auto-completion popups for tables, views, synonyms, and their columns. 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. Executing as a script will also generate errors from the RDBMS, unabling it to understand your statement. 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. Therefore, it keeps the parser fast and simple for Auto-Completion. The reason Aqua Data Studio does not use " " as a separator for SQL statements is because PL/SQL and T-SQL may contain " ". If you omit this, Aqua Data Studio will not perform effectively.ĭO NOT separate your statements with a semicolon " " 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. To use all of the Query Analyzer functionalities you need to separate your SQL statements by using ¨GO¨ or ¨/¨. Scripts and SQL Statement Separators: Only use GO or / You can change the database you are analyzing in the drop-down menu above the edit window. 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. Click here for a diagram of the toolbar button functions
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |