Documentation 7.0
Aqua Data Studio 7.0
1. Installation
    1.1 Minimum Requirements
    1.2 Installing Aqua Data Studio in Windows OS
    1.3 Installing Aqua Data Studio in Linux OS
    1.4 Installing Aqua Data Studio in Mac OS
    1.5 First steps towards Configuring
    1.6 Character set and Internationalization
2. Server Registration
    2.1 Supported RDBMS Servers in ADS 7.0
    2.2 How to Register a Server in ADS 7.0
    2.3 How to Edit Server Properties
    2.4 How to Copy Server Configurations
    2.5 Troubleshoot Registrations
    2.6 Tips and Tricks
    2.6.1 How to Register a Server Clone
    2.6.2 Tab Coloring to Identify Servers
    2.6.3 Using Filter Options in Registration
    2.6.4 Using Advanced Properties
    2.6.5 Permissions in Server Registration
    2.6.6 Drag and Drop Features
    2.6.7 Navigating with Short cut Keys
    2.6.8 SQL Express 2005
    2.6.9 MSDE 2000
    2.6.10 PostgreSQL SSL
    2.7. JDBC Drivers and Server Registration
        2.7.1 Oracle 8i JDBC Drivers
        2.7.2 Oracle 9i JDBC Drivers
        2.7.3 Oracle 10g JDBC Drivers
        2.7.4 Oracle 11g JDBC Drivers
        2.7.5 DB2 iSeries JDBC Drivers
        2.7.6 DB2 7.2 JDBC Drivers
        2.7.7 DB2 UDB 8.1 and DB2 UDB 8.2
        2.7.8 DB2 UDB 9.0 and DB2 UDB 9.5
        2.7.9 SQL Server JDBC Drivers
        2.7.10 Sybase ASE JDBC Drivers
        2.7.11 Sybase Anywhere JDBC Drivers
        2.7.12 Sybase IQ JDBC Drivers
        2.7.13 Informix JDBC Drivers
        2.7.14 PostgreSQL JDBC Drivers
        2.7.15 MySQL JDBC Drivers
        2.7.16 Apache Derby JDBC Drivers
        2.7.17 SQLite JDBC Driver
        2.7.18 Firebird JDBC Driver
3. Connecting to a Server (CTRL + INSERT)
4. Disconnecting a Server (CTRL + DELETE)
5. Query Analyzer - SQL Tool in ADS 7.0
    5.1 Invoking the Query Analyzer (CTRL+Q)
    5.2 Using the Query Analyzer
    5.3 Query Analyzer and its Environment
    5.4 Using Advanced Properties
    5.5 Parameterized Scripts
    5.6 Displaying Results of Queries
    5.7 Saving Query Results
    5.8 Tips and Tricks
6. SQL History (CTRL+ ALT+H)
7. Automate your SQL scripts using ADS 7.0
    7.1.1 Adding Insert, Update, Delete and Select
    7.1.2 Introduce Columns and Value Stubs
    7.1.3 Comments and Morph to Delimited Text
    7.1.4 Formatting Statements
    7.2 Auto Completion
    7.3 Aqua Commands
8. Query Builder Tool in ADS 7.0
    8.1 Using the Query Builder
    8.2 Advanced Properties and Features
9. Charting Tool in ADS 7.0
    9.1 Invoking Charting Tools in ADS 7.0
    9.2 Working with Grids
    9.3 Working with Pivot Grids
    9.4 Advanced Features of Charting Tools
    9.5 Sample Charting Demo
10. SQL Query Tuning - Visual Explain Tools
    10.1 Invoking Execution Plans
    10.2 Using Explain Diagrams
    10.3 Sample Query Tuning Demo
11. GUI Tools for Creating Database Objects
    11.1.1 Creating Tables
    11.1.2 Creating Constraints
    11.1.3 Creating Indexes
    11.1.4 Creating Views and Triggers
    11.1.5 Creating Aliases and Synonyms
    11.1.6 Creating Storage Objects
    11.2 Multi Scripting Objects
12. Tools and Features available in ADS 7.0
    12.1 How to Import Data using ADS 7.0
    12.2 How to Export Data using ADS 7.0
    12.3 Generate SQL Scripts using ADS 7.0
    12.4 Table Data Editor
    12.5 Server Script Generator
    12.6 Using Object Search in ADS 7.0
    12.7 Comparing two Database Schemas
    12.8 Using Explain White Board
    12.9 Using Execution Monitor
    12.10 Generating ER Diagrams
13. Procedure Editor
    13.1 Sample Stored Procedure
14. Function Editor
    14.1 Sample User Defined Function
15. Package Editor
    15.1 Sample Package Editing Demo
16. SQL Debugger
    16.1 Invoking ADS 7.0 SQL Debuggers
    16.2 Features of ADS 7.0 Debuggers
    16.2.1 Oracle Debugger
    16.2.2 DB2 Debugger
    16.2.3 MS SQL Debugger
    16.2.4 Sybase Debugger
    16.3 Debugging Stored Procedure Demo
    16.4 Tips and Tricks
17. ER Modeler in ADS 7.0
    17.1 Notation and Normalization
    17.2 Working with ER Modeler
    17.2.1 Creating Tables
    17.2.2 Creating Indexes
    17.2.3 Creating Constraints
    17.2.4 Creating Relationships
    17.2.5 Adding Notes and Regions
    17.2.6 Saving an ER Model
    17.3 Advanced Features
    17.4 Forward Engineering
    17.5 Reverse Engineering
    17.6 ER Modeler Demo
18. Version Control in ADS 7.0
    18.1 Using Subversion Repository
    18.2 Using CVS Repository
    18.3 Tips and Tricks
19. DBA Corner
    19.1 ORACLE DBA Tools
    19.1.1 Server Statistics
     19.1.2 Rollback Manager
     19.1.3 Log Manager
     19.1.4 Session Manager
     19.1.5 Instance Manager
     19.1.6 Storage Manager
     19.1.7 Security Manager
     19.1.8 SGA Manager
    19.2 SQL SERVER DBA Tools
    19.2.1 Instance Manager
    19.2.2 Session Manager
    19.2.3 Security Manager
    19.2.4 Storage Manager
    19.2.5 SQL Agent Manager
    19.3 SYBASE DBA Tools
    19.3.1 Instance Manager
    19.3.2 Session Manager
    19.3.3 Security Manager
    19.3.4 Storage Manager
    19.4 MySQL DBA Tools
    19.4.1 Instance Manager
    19.4.2 Session Manager
    19.4.3 Storage Manager
    19.4.4 Security Manager
    19.5 DB2 for LUW DBA Tools
    19.5.1 Instance Manager
    19.5.2 Session Manager
    19.5.3 Storage Manager
    19.5.4 Security Manager
20. Compare Tools in ADS 7.0
    20.1 File Compare
    20.2 Results Compare
    20.3 Directory Compare
    20.4 Tab Compare
    20.5 Schema Compare
    20.6 Copy History Compare
21. Editors available in ADS 7.0
    21.1.1 SQL Editor
    21.1.2 HTML Editor
    21.1.3 XML Editor
    21.1.4 Text Editor
    21.1.5 Regular Expressions
    21.2 Image Viewer
22. Application Workspace and Options
    22.1 Menus and Toolbar
    22.2 Shorcuts
    22.3 Schema and Script Browser
    22.4 Details View
    22.5 Tips and Tricks
24. Aqua Data Studio 7.0 OPTIONS
    24.1 General Options
    24.2 Editor Options
    24.3 Compare and Results Options
    24.4 Query Analyzer Options
    24.5 Scripts and Results Options
    24.6 Visual Explain Options
    24.7 Formatter Options
    24.8 Permissions and Registration Options
    24.9 Key Mapping Options and Key Assist Tool
    24.10 Settings: Find the application settings
25. Aqua Data Studio Technical Support
    25.1 Error Logging

21.1.5 Regular Expressions

Editors - Regular Expressions

The full regular expression syntax accepted by RE is described here:
Characters unicodeChar Matches any identical unicode character \ Used to quote a meta-character (like '*') \\ Matches a single '\' character \0nnn Matches a given octal character \xhh Matches a given 8-bit hexadecimal character \\uhhhh Matches a given 16-bit hexadecimal character \t Matches an ASCII tab character \n Matches an ASCII newline character \r Matches an ASCII return character \f Matches an ASCII form feed character Character Classes [abc] Simple character class [a-zA-Z] Character class with ranges [^abc] Negated character class NOTE: Incomplete ranges will be interpreted as "starts from zero" or "ends with last character". I.e. [-a] is the same as [\\u0000-a], and [a-] is the same as [a-\\uFFFF], [-] means "all characters". Standard POSIX Character Classes [:alnum:] Alphanumeric characters. [:alpha:] Alphabetic characters. [:blank:] Space and tab characters. [:cntrl:] Control characters. [:digit:] Numeric characters. [:graph:] Characters that are printable and are also visible. (A space is printable, but not visible, while an `a' is both.) [:lower:] Lower-case alphabetic characters. [:print:] Printable characters (characters that are not control characters.) [:punct:] Punctuation characters (characters that are not letter, digits, control characters, or space characters). [:space:] Space characters (such as space, tab, and formfeed, to name a few). [:upper:] Upper-case alphabetic characters. [:xdigit:] Characters that are hexadecimal digits. Non-standard POSIX-style Character Classes [:javastart:] Start of a Java identifier [:javapart:] Part of a Java identifier Predefined Classes . Matches any character other than newline \w Matches a "word" character (alphanumeric plus "_") \W Matches a non-word character \s Matches a whitespace character \S Matches a non-whitespace character \d Matches a digit character \D Matches a non-digit character Boundary Matchers ^ Matches only at the beginning of a line $ Matches only at the end of a line \b Matches only at a word boundary \B Matches only at a non-word boundary Greedy Closures A* Matches A 0 or more times (greedy) A+ Matches A 1 or more times (greedy) A? Matches A 1 or 0 times (greedy) A{n} Matches A exactly n times (greedy) A{n,} Matches A at least n times (greedy) A{n,m} Matches A at least n but not more than m times (greedy) Reluctant Closures A*? Matches A 0 or more times (reluctant) A+? Matches A 1 or more times (reluctant) A?? Matches A 0 or 1 times (reluctant) Logical Operators AB Matches A followed by B A|B Matches either A or B (A) Used for subexpression grouping (?:A) Used for subexpression clustering (just like grouping but no backrefs) Backreferences There are two different backreferences for regular expression and replacement string. In a regular expression: \1 Backreference to 1st parenthesized subexpression \2 Backreference to 2nd parenthesized parenthesized subexpression \3 Backreference to 3rd parenthesized subexpression \4 Backreference to 4th parenthesized subexpression \5 Backreference to 5th parenthesized subexpression \6 Backreference to 6th parenthesized subexpression \7 Backreference to 7th parenthesized subexpression \8 Backreference to 8th parenthesized subexpression \9 Backreference to 9th parenthesized subexpression
In a replacement string: $1 Backreference to 1st parenthesized group from the search string $2 Backreference to 2nd parenthesized group from the search string $3 Backreference to 3rd parenthesized group from the search string $4 Backreference to 4th parenthesized group from the search string $5 Backreference to 5th parenthesized group from the search string $6 Backreference to 6th parenthesized group from the search string $7 Backreference to 7th parenthesized group from the search string $8 Backreference to 8th parenthesized group from the search string $9 Backreference to 9th parenthesized group from the search string



All closure operators (+, *, ?, {m,n}) are greedy by default, meaning that they match as 
many elements of the string as possible without causing the overall match to fail. If you 
want a closure to be reluctant (non-greedy), you can simply follow it with a '?'. A 
reluctant closure will match as few elements of the string as possible when finding 
matches. {m,n} closures don't currently support reluctancy.

Line terminators
A line terminator is a one- or two-character sequence that marks the end of a line of the 
input character sequence. The following are recognized as line terminators:

A newline (line feed) character ('\n'),
A carriage-return character followed immediately by a newline character ("\r\n"),
A standalone carriage-return character ('\r'),
A next-line character ('?'),
A line-separator character ('?'), or
A paragraph-separator character ('?).

               
 
Regular Expressions