Goldview screen shot

Goldview 4

GoldView is a schema structure browser. It displays information on the structure and properties of schema objects. It is a read-only tool. It is useful for developers who need to know information about the objects in a schema, but don't want to type the data dictionary queries. It also allows safe browsing of schema information without the fear of accidentally damaging the database.

Buy now
  • Supported Client Operating systems: Windows 7 and above including Terminal Server/Citrix.
  • Supports Oracle 8 and above, including Oracle 21c. Requires a working Oracle Client, full or instant.
  • Displays objects in all accessible schemas
  • Colored syntax highlighting
  • Full Unicode support
  • Shows information on tables, views, triggers, indexes, synonyms, sequences, types and code modules
  • Shows structure, keys, constraints, indexes (including function based), stored code, DDL (CREATE SCRIPTS) and more!

GoldView

  • $20.00 (USD) per user
  • $15.00 (USD) per user when purchasing 5 or more user licenses at once
Buy now

All install files available from this site are Authenticode™ signed files. Authenticode identifies the publisher (Benthic Software) and verifies the integrity of the files.

All downloads include a free 30 day trial period.

Goldview 4: 32-bit

Latest 32-bit version - use with 32-bit Oracle client

Version (build): 4.0 (402)
Size: 5 MB
Version Date: March 28, 2023
Goldview 4: 64-bit

Latest 64-bit version - use with 64-bit Oracle client

Version (build): 4.0 (402)
Size: 6 MB
Version Date: March 28, 2023

Version 4.0 Build 402 - March 28, 2023

  • Fixed searching in the grid and code views.
  • Fixed an issue with the dark theme in 64bit.

Version 4.0 Build 401 - May 19, 2022

  • Updated interface to modern standards including Windows 11 support and dark and light themes.
  • High DPI screen support.
  • Added support for DBMS_METADATA output via Ctrl-Click of the Show DDL buttons.
  • Improved syntax highlighting and sample code display.
  • Improved line ending handling for code modules and triggers.

Version 3.0 Build 302 - April 13, 2011

  • Fixed: Trigger code would not show comments in the header section.

Version 3.0 Build 301 - March 7, 2011

  • Fixed: Build 300 was requiring users to enter their registration code even if the older version was properly registered.

Version 3.0 Build 300 - March 1, 2011

  • Added: Unicode support
  • Added: New Login window
  • Improved: Support for function based indexes
  • Improved: Speed improvements

Version 2.1 Build 191 - February 15, 2008

  • Fixed: Dictionary query error on Oracle 8.

Version 2.1 Build 190 - February 11, 2008

  • Fixed: Now properly uses CHAR length semantics when appropriate.

Version 2.1 Build 189 - March 9, 2007

  • Fixed: Fixed a problem with using "/@database as sysdba" in the login window.

Version 2.1 Build 188 - March 9, 2007

  • Fixed: Fixed a problem with "Large fonts" system setting.

Version 2.1 Build 187 - February 15, 2007

  • Added: Added a start menu link for the HTMLHelp version of the help file if you are using Vista (which doesn't support the old WinHelp help file version.)
  • Improved: Fixed some minor interface issues for Windows Vista. Please report any problems!
  • Fixed: Removed recyclebin objects from the object tree.
  • Fixed: Error using the Tools menu if logged in 'as sysdba' or 'as sysoper'.

Version 2.1 Build 186 - January 4, 2006

  • Improved: New menu style with menu icons.
  • Improved: Changes in 'Check web for update' procedure now uses system internet settings so it no longer requires setting proxy information for those using proxies. It now performs any needed download by requesting the download to be made from your default web browser.
  • Fixed: Using Alt-Letters or Alt-Arrows-Enter to choose menu options could cause an extra key to be sent if a new window was opened.
  • Fixed: Help system wasn't working.

Version 2.1 Build 185 - April 4, 2005

  • Added: Table DDL now shows table and columns comments. This can be turned off on the DDL options page.
  • Fixed: Sample data wasn't working for schema's or tables that needed double quoting.
  • Fixed: Table DDL would show inline NOT NULL constraints for columns where the NOT NULL condition was system generated. For example if the column was created without NOT NULL but was then used in the primary key.
  • Improved: Table DDL will now show named inline not null constraints. Since these constraint names don't appear in error messages they often aren't named.

Version 2.1 Build 184 - January 19, 2005

  • Fixed: Fixed a 'could not find oci.dll' problem with the Oracle 10g Instant Client.

Version 2.1 Build 183 - August 19, 2004

  • Fixed: DDL output for foreign constraints didn't properly handle referencing a table in a different schema.

Version 2.1 Build 182 - August 6, 2004

  • Added: Added support for new "Easy Connect" naming method of Oracle 10.
    • i.e.: [//]host[:port][/service_name]
      which needs no TNSNames.ora file so it's especially useful with the new "Instant Client"
  • Added: Now Database Aliases from TNSNames.Ora will be included in the drop down database list on the Login window. There are new options to turn this off and not have the names lowercased on the login options window. You can also edit the list there (note that this only affects the list, not TNSNames.Ora.)
  • Fixed: Usernames containing '-' were being forced to be case sensitive. This has been fixed.
  • Improved: Small fixes to schemalist optimization under certain conditions.

Version 2.1 Build 181 - March 1, 2004

  • Improved: Goldview's core keyword list has been increased and now only additions or subtractions to the list are saved in the options. You can remove a keyword by just adding it to the keyword list with a '-' at the front (i.e. -SELECT will remove select from the keyword list.)
  • Added: Cancel button to options window.
  • Fixed: Keywords weren't being saved.
  • Fixed: Some menu shortcuts weren't set.

Version 2.1 Build 180 - February 23, 2004

  • Added: DDL for GLOBAL TEMPORARY TABLES.
  • Added: USING INDEX clause for constraints.
  • Improved: Formatting of DDL was changed to more closely match the output of Oracle 9's DBMS_METADATA output.
  • Improved: If user has primary key or unique key constraints turned off in the options then associated indexes would be shown with their system generated name. Instead we now give the indexes a name reminding the user to rename them.
  • Improved: Removing blank values from physical/storage properties of ddl when appropriate.
  • Improved: Speeded up selecting and searching when the object list is large.
  • Fixed: Strip local owner name was stripping when it shouldn't.
  • Fixed: BITMAP indexes not in ddl.
  • Fixed: Index tablespace and storage clauses not in ddl.

Version 2.1 Build 178 - December 3, 2003

  • Connection code now matches latest version of Golden.
  • New Connection Diagnostics option on the help menu.
  • Data sample now works with Oracle 9 types.
  • Data sample speed improved.

Version 2.1 Build 176 - September 18, 2002

  • Added handling for changing your password if it has expired (Oracle 8+ feature.)
  • Fixed a problem where Goldview wouldn't use the dba_ views in some cases where it was appropriate to do so.

Version 2.1 Build 175 - July 2, 2002

  • Added support for bitmap indexes.
  • Change to support the read only setting of other Benthic applications.

Version 2.1 Build 174 - May 10, 2002

  • Several fixes to table DDL including correct handling for unique constraints.
  • Small change to fail over to use the all_ data dictionary tables if the user seems to have dba privileges but can't access the dba_ tables (in Oracle 9i the 'select any table' grant doesn't by default give access to the dba_ tables.)

Version 2.1 Build 172 - February 21, 2002

  • Changed the DDL queries to use the appropriate data dictionary views for the user (either dba_ or all_.)

Version 2.1 Build 171 - January 30, 2002

  • Separated the old 'CODE' section into separate 'functions/procedures' and 'packages' sections.
  • When a package or type is selected you can now click 'Show Header' or 'Show Body' buttons above the code display.
  • Added a find feature to the code and ddl displays. To bring up the find window just click in the code or ddl window before clicking Edit | Find or using Ctrl-F.
  • Added options to change the sort order and display of objects in the object tree.
  • Added line numbers to the code displays.
  • Brought Goldview's printing system up to the standards of Golden (page settings, print preview, syntax highlighting, etc.)
  • Changed the options on the 'Performance' tab of the options window. The default setting of 'Fast Owners Query' should work well for all but the largest databases. The 'Alternate fast Owners Query' should work well on large databases. Note that you have to re-login to see the change. The performance results are shown right after a login. Please let us know if none of the performance options work well for you!
  • Fixed a scrolling problem on DDL displays.

Version 2.0 Build 168 - January 16, 2002

  • Changed the table DDL to not include separate NOT NULL check constraints for columns with the NOT NULL column clause in the create table statement even if multiple NOT NULL check constraints appear in the system tables for that column.

Version 2.0 Build 167 - December 24, 2001

  • Fixed a bug in the Primary Key DDL if the primary key wasn't at the beginning of the column list.

Version 2.0 Build 166 - November 30, 2001

  • Fixed a bug where Goldview wasn't remembering the Font 'script' setting.

Version 2.0 Build 165 - November 7, 2001

  • Fixed a bug where "CACHE 0" was used in the sequence DDL instead of "NOCACHE".

Version 2.0 Build 164 - November 3, 2001

  • Fixed a bug where sequence CACHE would be blank. Note that there will be no CACHE clause in the DDL if the CACHE size is the default (20).
  • Added associated INSTEAD OF triggers to view DDL.

Version 2.0 Build 163 - October 29, 2001

  • Added the ability to show DDL (data definition language - basically the SQL to re-create the object) to all objects. Note that some icons like 'show code' for procedures and 'show text' for views have been changed to the more generic 'show ddl for object'. Please let us know (support@benthicsoftware.com) if you have any problems or suggestions for this feature. Note that there is a new 'Options' page called 'DDL Settings' where you can tweak the generated SQL.
  • Added column click sorting to the Table Structure, Table Sample Data, View Structure and View Sample Data displays. Just click a column header to sort and click it again to reverse sort.

Version 1.9 Build 159 - June 15, 2001

  • Added a check for the SELECT_CATALOG_ROLE.
  • Changed data dictionary lookups to use the DBA_ catalog tables when user is a DBA or has DBA-like rights.

Version 1.9 Build 157 - April 26, 2001

  • Added a new menu called 'View' with options for word wrapping source code and syntax highlighting source code. These options are persistant. There is also a new 'Syntax Highlighting' options page.
  • Added support for TYPE and TYPE BODY.
  • Fixed a 'grid index out of bounds' error when using the mouse wheel.
  • Added 'order by column_id' to the View structure query.

Version 1.9 Build 153 - September 12, 2000

  • Modified the color settings on a number of the windows to use the standard system wide WindowsText color for fonts (it was using black which caused obvious problems if you used a black window background setting.)

Version 1.9 Build 152 - August 25, 2000

  • This release is to fix an incompatibility with Computer Associate's Innoculate Antivirus software.

Version 1.9 Build 150 - March 28, 2000

  • Moved Program Options to the tools menu to match other tools.
  • New Disconnect menu item.
  • New Network code as in Golden.

Version 1.9 Build 149 - January 14, 2000

  • Fixed the printing which became broken in build 148.

Version 1.9 Build 148 - January 4, 2000

  • Now 'Copy selection' works correctly for non-spreadsheet items.
  • Added a date format setting on the show page of the options window to set the date format for the datasample view.

Version 1.9 Build 147 - July 19, 1999

  • Added Unregister program and Check web for new version to the Help menu.
  • Fixes a problem when using the Tools menu to go to other app when a hardcoded oci.dll is used.
  • The Tools menu will now work when the applications are in different directories. Note that the individual apps have to be run once 'solo' so that their locations can be entered into the registry.

Version 1.9 Build 146 - July 15, 1999

  • Includes the new login window and options from Golden and PLEdit.
  • Updated help file.

Version 1.9 Build 142 - June 17, 1999

  • Actually made the Net8i code work!
  • New login screen with user requests and right click menus.

Version 1.9 Build 141 - April 14, 1999

  • Changes for Net8 8.1.x.

Version 1.9 Build 140 - February 19, 1999

  • Changed object tree search to allow forward/reverse searching. While focus is on search field:
    • Enter = Search Down
    • Shift-Enter = Search Up
    • Down Arrow = Search Down
    • Up Arrow = Search Up
  • New Hotkeys:
    • F5 = Refresh (Microsoft standard)
    • Ctrl-J = Login (Compatible with Oracle's tools?)
    • F3 = Find
    • Ctrl-F = Find

Version 1.9 Build 139 - February 18, 1999

  • Added new login screen to match Golden and PLEdit. (Quick Login features)
  • Added new option on the Show page to remove the owner name from the object tree when it isn't needed.
  • Added new optional setting so that object tree refreshes only happen when the refresh button is pushed.
  • Added an object tree search field. Note: Press Enter in the search field to search.

Version 1.9 Build 137 - September 29, 1998

  • Removed length constrains on display of code text.
  • Added Tab size option to the Program Options|Editor page.

Version 1.9 Build 136 - August 18, 1998

  • Changed DBA schema lookup to avoid the use of dba synonyms.
  • Fixed a problem when loading schemas and not using the 'fast' query option.

Version 1.9 Build 134 - August 12, 1998

  • Added an option to change the number of rows shown in a data sample.

Version 1.9 Build 132 - July 28, 1998

  • Made initialization MUCH fast for DBAs.
  • Fixed some problems with viewing trigger code in other schemas.
  • Added proper headers to trigger code text and view text.
  • Added owner name to code module text in other schemas.
  • Added option to start with a collapsed object tree.

Version 1.9 Build 130 - June 18, 1998

  • Now works with Oracle8/Net8.
  • Some user interface changes.
  • More options for performance and display.
  • Added Indexes to object tree.

Version 1.8 Build 124 - Dec 11, 1997

  • Added Program Options to file menu.
  • Added font selection to program options.

Version 1.8 Build 123 - Dec 1, 1997

  • Fixed problem registering.
  • Changed Hot keys 1-9 to Ctrl 1-9.

Version 1.8 Build 118 - August 6, 1997

  • Fixed and improved keyboard interface.
    Hot keys:
    • 1-9 clicks corresponding button on the current toolbar.
    • Shift-Arrows moves through list without refreshing.
  • Added Object list when 'subject' nodes are selected.

Version 1.7 Build 117 - July 11, 1997

  • Add version info and build number to about box.
  • Started History file!