Oracle

Oracle: Stored procedure/function columns are listed several times
Note: This applies only when using DbVisualizer Free or when the "generic" database profile is loaded in DbVisualizer Pro. Selecting a stored ...
Wed, 12 Jul, 2017 at 7:56 PM
Oracle: Stored procedures/functions are displayed several times
Note: This applies only when using DbVisualizer Free or when the "generic" database profile is used in DbVisualizer Pro. Stored procedures/fun...
Wed, 12 Jul, 2017 at 7:56 PM
Oracle: Some stored procedure/functions are displayed as "xx.yy" in the database objects tab
Note: This applies only when using DbVisualizer Free or when the "generic" database profile is loaded in DbVisualizer Pro. Oracle has the abil...
Wed, 12 Jul, 2017 at 7:56 PM
Oracle: DDL tab doesn't show for Oracle even if using Oracle 9 or later
The DDL feature requires a JDBC 3 compliant driver. Make sure you your are using the latest available JDBC driver from the Oracle web site.
Mon, 27 Jul, 2015 at 2:32 PM
Oracle: How do I execute SELECT statements that contain hints
Oracle hints are supported from DbVisualizer 8.0. The following is applicable for older versions. Block comments identified by /* ... */ are automa...
Wed, 12 Jul, 2017 at 7:56 PM
Oracle: Synonyms are not displayed in the Query Builder or when using auto completion in the SQL editor
In the Properties tab for the connection, select Driver Properties. Then either locate the includeSynonyms parameter in the list or insert it. Set the value...
Wed, 12 Jul, 2017 at 7:57 PM
Oracle: Connecting using a TNS name
All information for connecting to an Oracle database may be stored in a tnsnames.ora file, with each database instance defined by a TNS alias. If you want...
Wed, 12 Jul, 2017 at 7:57 PM
Oracle: There are no columns listed for database Views
Having the includeSynonyms driver property set to true in the Properties tab and the Driver Properties category will result in no columns being displayed f...
Wed, 12 Jul, 2017 at 7:57 PM
Oracle: Error when connecting to Oracle 8i
If you get an error similar to the following it is most likely because the JDBC driver bundled with DbVisualizer is not compatible with Oracle 8i. An e...
Wed, 12 Jul, 2017 at 7:57 PM
Oracle: It takes a very long time to start DbVisualizer
In some configurations, having the ORACLE_HOME or TNS_ADMIN environment variables pointing to a remote device that is not available or responsive can make s...
Wed, 12 Jul, 2017 at 7:57 PM