![]() The default font used by ADS does not support all charactersets, so if you need support for Japanese, Chinese and other languages you may need to change your font by selecting File-Options->General->Appearance and select an appropriate font. The bundled JRE which comes with ADS is the International version, but if you are using your own you must make sure it supports International charactersets. Unicode/Charactersets -ADS supports Unicode and International charactersets, but you must make sure you are using the international JRE and that ADS is using a font which supports the characterset you are using. ADS also supports the saving of resultsets into different encoding types. When opening an SQL Script select the ’File Type’ with the appropriate encoding. Abbreviations are set within File->Options->Editors->SQL Editor->Abbreviations.ĪDS supports SQL Scripts encoded in different encoding formats. There are a selection of key combinations to trigger the expansion of an abbreviation. With a few keystrokes an entire block of SQL commands can be inserted. Although the query window will intelligently decide when to popup options, you may activate the auto-completion feature with the CTRL-SPACE hot key.Ībbreviation Support - User-defined abbreviations, created within the SQL Editor Options, function as customizable autocompletion strings. 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. This might give you the impression that Aqua Data Studio’s features do not work. 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. Executing as a script will also generate errors from the RDBMS unable to understand your statement. A function can accept parameters passed by value, while a procedure can accept parameters as passed by reference only. A function can be called from SQL queries, while a procedure can never be invoked from SQL. 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. A function must mandatorily return a value, while a procedure may or may not. To keep the parser fast and simple for Auto-Completion and Describe we do not use it. Check out #2 and #3.ĭO 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 " ". If you do not do this you might get the impression that Aqua Data Studio doesn’t work. 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. Separate your statements with "GO" or "/" - To correctly use all of Query Analyzer’s functionality you need to separate your SQL Statements. Scripts and SQL Statement Separators: ONLY USE GO or / You can quickly change the database you are analyzing in the dropdown menu above the edit window. Toolbar Functionality - The toolbar allows you create a new Query, open scripts, save scripts, save results, copy content, cut content, paste content, undo, redo, find, find and replace, change case, parse, execute, execute current, execute edit, execute explain, stop execution, autocommit, commit, rollback, reconnect, enable autocompletion, refresh the auto schema, run a parameterized script and set the maximum results displayed. ![]() PL/SQL engine can process the multiple SQL statements simultaneously as a single block hence reduce network traffic and provides better performance.Click here for a diagram of the toolbar button functions ![]() ![]() Every PL/SQL statement will be followed by semicolon ( ).Ģ. Read more on Aqua Data Studios Pivot Grid Charts here. It is used to handle the exceptions occurred in execution section. Exception handling section:Įxecution section starts with EXCEPTION keyword. Note: Execution section must have one statement. It is used to write the program logic code. Execution section:Įxecution section starts with BEGIN keyword and ends with END keyword. It is used to declare the variables, constants, records and cursors etc. It is an optional section and starts with DECLARE keyword. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |