You can use these DbVisualizer client-side commands in your SQL scripts. (These commands are processed by DbVisualizer and never sent to the database as-is).
|Use these command to execute an external script.|
Use this command to export the result of a query or procedure call to a file.
|Use this command to temporarily change the statement delimiter for a complex statement.|
|Use this command to execute a function or procedure.|
|Use this command to emit a beep sound, e.g. to indicate a significant point in a script.|
|Use this command to halt the processing the specified number of milliseconds.|
|Use this command to write to the Log tab.|
|Use these commands to lower (iconify) or raise (restore) the DbVisualizer main window.|
|Use this command to show column information for a table. The table name may be qualified with a schema and/or database name.|
|Use this command to get the DDL for a database object.|
Use this command to write log messages to a named file. Examples
|This command is not supported any more. Please use the @log command instead.|
|Use these commands to control what to do when a statement results in a warning or an error.|
Use these commands to control the Auto Commit state.
|Use these commands to explicitly commit or rollback updates.|
|Use these commands to enable or disable output to the DBMS Output tab for Oracle databases.|
|Use these commands to adjust the Max Rows and Max Chars limits for specific queries.|
Use this command to name any following result set. When executed with a following SQL statement that produces a result set the tab showing this result set will be named using the <name> supplied as a parameter to the command.
DbVisualizer will for the example above show the result of the select in a tab named MyEmployees