

Dbvisualizer Pro

This article shows how to establish a connection to Oracle data in DBVisualizer and use the table editor to edit and save Oracle data. Create a New JDBC Data Source for Oracle Data. Follow the steps below to use the Driver Manager to provide connectivity to Oracle data from DBVisualizer tools. DbVisualizer is a feature-rich, intuitive, cross-platform database tool for developers and DBA's providing a single powerful interface for a variety of databases. DbVisualizer supports simultaneous database connections; it lets you explore and manage database objects, execute SQL queries, visualize information,.
Dbvisualizer Free Vs Pro
Object Type | Actions | Viewers |
---|
|
Databases |
Create Database Databases, Session SQL Mode
1CatalogExport Database, Drop Database Catalog
TablesCreate Table, Import Table DataReferences, Tables
TableAlter Table, Create Trigger, Export Table, Import Table Data, Analyze Table
1, Check Table
1, Checksum Table
2, Create Index, Drop Table, Empty Table, Optimize Table
1, Rename Table, Repair Table
1, Script: Script Table Navigator
3, References, Data, Columns, DDL, Grants, Indexes, Info, Native DDL, Primary Key, Row Count, Row Id, Triggers
4Columns Columns
Column Column
Indexes Indexes
IndexDrop Index Index
Triggers4 Triggers
TriggerExport Trigger, Drop Trigger Trigger Editor, Info
Views4 Views
ViewExport View, Drop View, Rename View, Script: Script View Data, Columns, DDL
4, Grants, Info, Row Count
Columns Columns
Column Column
Procedures4Create Procedure
5, Create Procedure
6 Stored Procedures
ProcedureExport Procedure, Drop Procedure, Script: Script Procedure Procedure Editor, Info
Functions4Create Function
5, Create Function
6 User Functions
FunctionExport Function, Drop Function, Script: Script Function Function Editor, Info
Triggers4 Triggers
TriggerExport Trigger, Drop Trigger Trigger Editor, Info
Events7Create Event, Start/Stop Event Scheduler Events
EventAlter Event, Drop Event, Enable/Disable Event, Rename Event Info
Sequences8Create Sequence Sequences
SequenceDrop Sequence, Rename Sequence, Script: Script Sequence DDL, Info
PackagesCreate Package Packages
PackageCreate Package Body, Export Package, Drop Package and Package Body Package Specification Editor
PackageBodyExport Package Body, Drop Package Body Package Body Editor
PackageBodiesCreate Package Body Package Bodies
PackageBodyExport Package Body, Drop Package Body Package Body Editor
DBA DBA
UsersCreate User Users
LoginDrop User Privileges, Show Grants
Privileges1 Server Privileges
Processes Processes
ProcessKill Session Process
Status Charset
1, Colllation
1, Slave Hosts
1, Slave Status
1, Status, Variables
TableEngines1 Table Engines
TableEngine Mutex, Status
Warnings4 Errors, Warnings
1)Version 4.1 and later 2)Version 4.2 and later 3)DbVisualizer Pro 4)Version 5.0 and later 5)Using ORACLE_SQLMODE 6)Using ORACLE_SQLMODE 7)Version 10.4 and later 8)Version 10.3 and later