Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Include Page
_MixVariablesAndMarkersWarning
_MixVariablesAndMarkersWarning

Named Parameter Markers

Include Page
_ParmMarkersNamed
_ParmMarkersNamed

...

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
_ParmMarkersUnnamed
_ParmMarkersUnnamed

...

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.

...