Page History
...
| Include Page | ||||
|---|---|---|---|---|
|
Named Parameter Markers
| Include Page | ||||
|---|---|---|---|---|
|
...
| Info |
|---|
To apply the values, close the window and continue with the execution, use key binding Ctrl+Enter (Command+Enter on Mac OS X). |
Unnamed Parameter Markers
| Include Page | ||||
|---|---|---|---|---|
|
...
| Info |
|---|
To apply the values, close the window and continue with the execution, use key binding Ctrl+Enter (Command+Enter on Mac OS X). |
Get Parameter Types via JDBC
The processing of named and unnamed parameter markers is managed by DbVisualizer. By default there is no data type detection of the target columns identified by the markers and DbVisualizer will initially present these as String in the prompt window. When changing the value for a parameter in the prompt window, a data analyzer is triggered which will automatically detect the type and update the Type field accordingly.
...
| Warning |
|---|
Having Get Parameter Types via JDBC enabled while executing may decrease performance substantially as each SQL statement in the script is then pre-processed with the database before the prompt window is displayed. |
Database Support/Driver Support
The support for parameter markers may differ between databases. Please consult the documentation for the database to see what syntax it supports.
...
Overview
Content Tools