Generally, only the question mark
? is treated as a parameter in SQL statements. On this page, you can specify which other characters and their sequences should be treated as parameters, and in which places.
The patterns for SQL parameters are specified by means of regular expressions.
Executing parameterized statements
If you have parameters in your statement, you must specify the values of the parameters before you execute the statement.
To execute a parameterized statement, click the Execute button on the toolbar and enter values in the second column. Alternatively, to open the Parameters dialog, click the View Parameters button .
Configure settings for user parameters
Open settings by pressing ⌃⌥S and navigate to . See description of user parameters in the following table.
|Enable in console and SQL files|
If the checkbox is selected, the parameter patterns are applied to SQL (in SQL files and database consoles). The usage scope, if necessary, may be limited at the level of individual patterns.
If this checkbox is cleared, the patterns are not used in SOL files and consoles irrespective of which usage scope is specified for individual patterns.
|Enable in string literals with SQL injection|
If the checkbox is selected, the parameter patterns are applied to string literals injected with SQL. If necessary, you can limit the usage scope at the level of individual patterns.
If this checkbox is cleared, the patterns are not used in string literals irrespective of which usage scope is specified for individual patterns.
The table shows the parameter patterns and their usage scopes.
The patterns are specified using regular expressions. Values in parentheses are treated as parameter names. The patterns available initially have the following meanings:
Use ⌘N, ⌥⌦, ⌥↑ and ⌥↓ to add, delete and reorder the patterns.
To edit a pattern or its usage scope, click the pattern and use the following controls: