

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 Mode1 | |
| Catalog |
Export Database, Drop Database | Catalog | |
| Tables |
Create Table, Import Table Data | References, Tables | |
| Table |
Alter Table, Create Trigger, Export Table, Import Table Data, Analyze Table1, Check Table1, Checksum Table2, Create Index, Drop Table, Empty Table, Optimize Table1, Rename Table, Repair Table1, Script: Script Table | Navigator3, References, Data, Columns, DDL, Grants, Indexes, Info, Native DDL, Primary Key, Row Count, Row Id, Triggers4 | |
| Columns |
Columns | |
| Column |
Column | |
| Indexes |
Indexes | |
| Index |
Drop Index | Index | |
| Triggers4 |
Triggers | |
| Trigger |
Export Trigger, Drop Trigger | Trigger Editor, Info | |
| Views4 |
Views | |
| View |
Export View, Drop View, Rename View, Script: Script View | Data, Columns, DDL4, Grants, Info, Row Count | |
| Columns |
Columns | |
| Column |
Column | |
| Procedures4 |
Create Procedure5, Create Procedure6 | Stored Procedures | |
| Procedure |
Export Procedure, Drop Procedure, Script: Script Procedure | Procedure Editor, Info | |
| Functions4 |
Create Function5, Create Function6 | User Functions | |
| Function |
Export Function, Drop Function, Script: Script Function | Function Editor, Info | |
| Triggers4 |
Triggers | |
| Trigger |
Export Trigger, Drop Trigger | Trigger Editor, Info | |
| Events7 |
Create Event, Start/Stop Event Scheduler | Events | |
| Event |
Alter Event, Drop Event, Enable/Disable Event, Rename Event | Info | |
| Sequences8 |
Create Sequence | Sequences | |
| Sequence |
Drop Sequence, Rename Sequence, Script: Script Sequence | DDL, Info | |
| Packages |
Create Package | Packages | |
| Package |
Create Package Body, Export Package, Drop Package and Package Body | Package Specification Editor | |
| PackageBody |
Export Package Body, Drop Package Body | Package Body Editor | |
| PackageBodies |
Create Package Body | Package Bodies | |
| PackageBody |
Export Package Body, Drop Package Body | Package Body Editor | |
| DBA |
DBA | |
| Users |
Create User | Users | |
| Login |
Drop User | Privileges, Show Grants | |
| Privileges1 |
Server Privileges | |
| Processes |
Processes | |
| Process |
Kill Session | Process | |
| Status |
Charset1, Colllation1, Slave Hosts1, Slave Status1, 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
|