DbVisualizer 9.5 Users Guide

Users Guide


Download PDF
Older versions

Versions Compared

Old Version 5

changes.mady.by.user Ulf Weiland

Saved on

compared with

New Version Current

changes.mady.by.user Ulf Weiland

Saved on

Key

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

...

CommandDescription
@cd <directory>
@run <file> [ <variables> ]		Use these command to execute an external script.
@export
Index term
secondaryexport
primaryresult set
Use this command to export the result of a query or procedure call to a file.
@delimiter <new_delimiter>Use this command to temporarily change the statement delimiter for a complex statement.
@call <function_or_proc>Use this command to execute a function or procedure.
@beepUse this command to emit a beep sound, e.g. to indicate a significant point in a script.
@sleep <milliseconds>Use this command to halt the processing the specified number of milliseconds.
@echo <text>Use this command to write to the Log tab.

@window iconify
@window restore

Use these commands to lower (iconify) or raise (restore) the DbVisualizer main window.
@desc <table>Use this command to show column information for a table. The table name may be qualified with a schema and/or database name.
@ddl <params>Use this command to get the DDL for a database object.
@spool log <file_name>Use this command to write log messages to the named file. When executed in the SQL Commander, all log messages produced up to this point are written to the file; if Log to File is selected, this command is ignored. When executed by the pure command line interface, all log messages produced from this point onward are written to the file.

@stop on error
@stop on warningsqlwarning
@stop on norows
@continue on error
@continue on warningsqlwarning
@continue on norows 

Use these commands to control what to do when a statement results in a warning or an error.

@set autocommit on
@set autocommit off

Index term
secondarycommit/rollback
primarytransaction
Use these commands to control the Auto Commit state.

@commit
@rollback

Use these commands to explicitly commit or rollback updates.

@set serveroutput on
@set serveroutput off

Use these commands to enable or disable output to the DBMS Output tab for Oracle databases.

@set maxrows <number>
@set maxchars <number>

Use these commands to adjust the Max Rows and Max Chars limits for specific queries.

@set resultset name <name>

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.

Example:

Code Block
languagesql
@set resultset name MyEmployees;
select * from EMPLOYEE;

DbVisualizer will for the example above show the result of the select in a tab named MyEmployees