oracle
Oracle Tested for version 8i - 21c
Overview JDBC Drivers Features Supported Objects Download

FEATURES FOR oracle

Features available to Oracle users.

The following table shows the available features for working with Oracle across the Pro and Free versions of DbVisualizer.

Supported OS'es

 
Feature
DbVisualizer Pro
DbVisualizer Free
Feature
Runs on Windows, macOS, and Linux/UNIX
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Configurable key bindings with pre-defined key maps
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Light and Dark themes
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
High resolution images and icons for HiDPi displays
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Installers with bundled Java (no manual Java install)
DbVisualizer Pro
Yes
DbVisualizer Free
Yes

The DbVisualizer UI

 
Feature
DbVisualizer Pro
DbVisualizer Free
Feature
Rearranging tabs using drag&drop
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Maximize tabs with double-click
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Detach tab in separate Window
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Pin tabs
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Tile/Collapse all tabs in a tab group
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Specify default naming scheme for tabs
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Rename individual tabs
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Save layout of Object View tabs between DbVisualizer sessions
DbVisualizer Pro
Yes
DbVisualizer Free
No

Connection Management

 
Feature
DbVisualizer Pro
DbVisualizer Free
Feature
Dynamic JDBC driver management with Maven, file, and http support
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
JDBC drivers included with DbVisualizer:
  • Azure SQL Database
  • Db2 for LUW
  • Derby
  • Exasol
  • H2
  • Greenplum
  • MariaDB
  • Mimer SQL
  • MySQL
  • NuoDB
  • PostgreSQL
  • Oracle
  • Redshift
  • SQLite
  • SQL Server
  • Sybase SQL Anywhere
  • Sybase ASE
  • Vertica
  • Yellowbrick
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
SSH support with known_hosts, ssh-agent, and private key support
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Connection Keep-Alive
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Optionally use a single physical connection for all operations
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Organize database connections in folders
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Set individual tab background color and borders for each connection
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Parameterized connection data
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Supports multiple simultaneous open database connections
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Connect a single or multiple connections with a single click
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Export and Import connections and general user settings
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Basic password Security
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Strong master password Security
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Show passwords in plain text if using master password Security
DbVisualizer Pro
Yes
DbVisualizer Free
Yes

Database Browser

 
Feature
DbVisualizer Pro
DbVisualizer Free
Feature
A tree structure to browse and manage database objects
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Multi-object support for open, connect, drop, etc
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Generic database support
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
View basic information for
        tables, indexes, primary keys, privileges,
        schemas, databases, procedures and a lot more
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Type-to-find objects by name
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Database objects filtering
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Hide database objects
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Sort database connections and folders
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Search database objects
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Show only default database/schema
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Organize database connections and folders with drag&drop
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Script multiple database objects using drag&drop
DbVisualizer Pro
Yes
DbVisualizer Free
No

Table

 
Feature
DbVisualizer Pro
DbVisualizer Free
Feature
Create and Alter table
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Define Referential Integrity Constraints
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Rename Table
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Drop Table
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Empty Table
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Create Index
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Table DDL viewer
DbVisualizer Pro
Yes
DbVisualizer Free
No

Procedure, Function, Package and Trigger

 
Feature
DbVisualizer Pro
DbVisualizer Free
Feature
Create Procedure, Function, Package, Trigger
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Edit Procedure, Function, Package, Trigger
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Execute Procedure, Function
DbVisualizer Pro
Yes
DbVisualizer Free
No

Export Schema/‌Database

 
Feature
DbVisualizer Pro
DbVisualizer Free
Feature
Export Formats
DbVisualizer Pro
CSV, HTML, SQL, XML, XLS, XLSX, JSON
DbVisualizer Free
No
Feature
Export object DDLs
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Export Table Data
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Custom Data Format Settings
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Support for BLOB, CLOB and binary data
DbVisualizer Pro
Yes
DbVisualizer Free
No

References Graphs

 
Feature
DbVisualizer Pro
DbVisualizer Free
Feature
Graph or list of referential integry rules
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Several automatic graph layout managers
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Link table nodes by foreign keys
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Link table nodes by all cols in a foreign key
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Bridge link support to improve readability
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Graph zooming, fit, animation and navigator pane
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Show Table details
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Script Tables as SQL by SELECT, INSERT, CREATE, etc.
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Export
DbVisualizer Pro
EMF, GIF, JPEG, PDF, PNG, SVG
DbVisualizer Free
EMF, GIF, JPEG, PDF, PNG, SVG
Feature
Print
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Save/Load manual layouts
DbVisualizer Pro
Yes
DbVisualizer Free
Yes

Database Scheduling, Events, Jobs

 
Feature
DbVisualizer Pro
DbVisualizer Free
Feature
Manage jobs and scheduling in "Oracle Scheduler"
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Manage jobs and scheduling in "SQL Server Agent"
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Manage jobs and scheduling in "PostgreSQL pgAgent"
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Manage jobs and scheduling in "MariaDB Events"
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Manage jobs and scheduling in "MySQL Events"
DbVisualizer Pro
Yes
DbVisualizer Free
Yes

Table Data Viewer/Editor

 
Feature
DbVisualizer Pro
DbVisualizer Free
Feature
Table data editing in grid (spreadsheet like) editor
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Table data editing in form editor
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Auto-complete col names while writing WHERE filter
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Table filters saved between sessions
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Copy/Paste with external spreadsheet tools such as Excel
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
One-click open of grid data in native spreadsheet tool (Excel, Numbers, LibreOffice, etc)
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Quick filtering in grids
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Display references to other tables
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Monitor row count differences
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Support for BLOB, CLOB and binary data
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
View BMP, TIFF, PNG, GIF and JPEG images
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
View PDF documents
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
View XML data in tree or text format
DbVisualizer Pro
Yes
DbVisualizer Free
No

Table Export

 
Feature
DbVisualizer Pro
DbVisualizer Free
Feature
Export Formats
DbVisualizer Pro
CSV, HTML, SQL, XML, XLS, XLSX, JSON
DbVisualizer Free
No
Feature
Export CREATE DDL for SQL format
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Export INDEX DDL for SQL format
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Custom Data Format Settings
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Support for BLOB, CLOB and binary data
DbVisualizer Pro
Yes
DbVisualizer Free
No

Table Data Import

 
Feature
DbVisualizer Pro
DbVisualizer Free
Feature
Import table data from CSV or Excel files
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Support for BLOB, CLOB and binary data
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Support multi-character col separator
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Automatic data type detection
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Automatic mapping of file cols to table cols
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Create table from imported data
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Save settings between sessions
DbVisualizer Pro
Yes
DbVisualizer Free
No

Data Navigator

 
Feature
DbVisualizer Pro
DbVisualizer Free
Feature
Expose foreign keys by data selection
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Limit referenced data with filters
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Tag support
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Edit table data directly in Navigator
DbVisualizer Pro
Yes
DbVisualizer Free
No

SQL Query Tool

 
Feature
DbVisualizer Pro
DbVisualizer Free
Feature
Execute Script with multiple SQL statements
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Execute single SQL statement at cursor position
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Execute selected SQL statement(s)
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Execute Buffer (as a single SQL statement)
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Execute Explain Plan
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Syntax colored SQL editor
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Auto Completion (aka code completion, intellisense)
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Predefined and user defined editor templates
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Support for multiple SQL editors
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Support for procedures producing multiple result sets
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
SQL formatter with extensive customization options
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Execution control (stop on error/warning)
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
View result sets as grid, text or chart
DbVisualizer Pro
Grid, Text, Chart
DbVisualizer Free
Grid
Feature
Editable result sets with the inline or form editors
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Support for BLOB, CLOB and binary data
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
View BMP, TIFF, PNG, GIF and JPEG images
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
View PDF documents
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
View XML data in tree or text format
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Export result sets with Create Table option
DbVisualizer Pro
CSV, HTML, XLS, XLSX, XML, SQL
DbVisualizer Free
CSV, HTML
Feature
Export large result sets directly to file (@export)
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Parameterized SQL queries
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Supports objects dragged from the Database Browser
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Drop files from Desktop or external tools
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
SQL execution logging with filtering options
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Pre-defined editing key maps
DbVisualizer Pro
Yes
DbVisualizer Free
Yes
Feature
Merge Result Sets in Text Format
DbVisualizer Pro
Yes
DbVisualizer Free
No
Feature
Error highlighting in editor
DbVisualizer Pro
Yes
DbVisualizer Free
No

Result Set Management

 
Feature
DbVisualizer Pro
DbVisualizer Free
Feature
Auto resize columns, manual column resizing
DbVisualizer Pro
Yes