Golden 7.x
Golden is a query tool for Oracle databases. It includes advanced query abilities, data editing, and powerful import and export abilities including support for Excel and Calc spreadsheets. It features close compatibility with SQLPlus scripting conventions including bind variables, variable prompting and script parameter passing. See the history tab below to see Golden 7's exciting new features!
- 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.
- Full Unicode support.
- SQL query and script running including database specific commands, stored procedures, etc.
- Edit and run multiple scripts simultaneously.
- SQL editor with context sensitive highlighting and popup table/field lists.
- View schema information and easily paste into queries and scripts.
- Incredibly fast data grid with support for transposed mode, sorting, custom formatting, filtering and more.
- Editing of query results with full transaction control.
- Cell detail window for viewing multi-line or formatted text.
- Image viewer cell detail window with support for Jpg, Gif, Png, Bmp, Tif, MultiPage Tif, etc.
- Format SQL statements with built in SQL formatter.
- Export data to Excel, Calc, CSV, XML, insert statement scripts, and more. Exports can also be scripted and run automatically using command line options.
- Export to Excel and Open Office Calc through COM automation.
- Export directly to Excel files (.xls, .xlsx) even if Excel is not installed.
- Language copy & paste feature for integration with programming tools such as PHP, JavaScript, C++, VB, Object Pascal and more.
- Support for SQLPlus variable prompting, bind variables (including RefCursor), and calling external scripts with parameter passing.
- Support for EXEC, DESC and CONNECT statements.
- Support for DBMS Output.
- Script and statement timing.
- Use command line options and script commands to automate the running of scripts.
- Explain Plan output.
- Support for SQLPlus style SPOOL files.
- Customizable toolbars and hotkeys.
- Enterprise friendly with no internet connection required to use the application and easy to set read-only mode.
- A sophisticated separate import/export application (ImpExpLite) that can handle millions of records.
Golden 7.x
- $50.00 (USD) per user
- $45.00 (USD) per user when purchasing 5 to 19 user licenses at once
- $40.00 (USD) per user when purchasing 20+ user licenses at once
Golden 7.x upgrade
- $40.00 (USD) per user
- $36.00 (USD) per user when purchasing 5 to 19 user licenses at once
- $32.00 (USD) per user when purchasing 20+ user licenses at once
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.
Version 7.4 Build 740 - March 31, 2024
- New ability to pin login items to the top of the login list.
- New handling for the Show command including show create table.
- The cell detail window can now be displayed in Edit mode.
- Added new COLUMN LOOKUP script command to add dropdown lists for edit fields.
- Added new COLUMN BLOBEDIT script command to add a "file load" button to edit fields that are blobs.
- Added new help menu item to show script command help.
- Improved display of table and column comments as popup hints in the SQLBuilder.
- Improved handling of logins using alternate schemas.
- Improved performance and appearance when using dark mode.
Version 7.3 Build 738 - Feb 14, 2024
- Fixed an issue showing column lists on certain Oracle 9 databases.
- Performance improvement when showing constraints and indexes.
Version 7.3 Build 734 - December 28, 2023
- New Tabs main menu which can be sorted alphabetically or by tab position.
- Show column comments as a popup hint in the SQLBuilder.
- Won't prompt for password change if using autorun script option (-a command-line option.)
- Improved error reporting in ImpExpLite, particularly related to incorrect file encodings.
- Fixed printing issue with SQL where last line might not print.
- Fixed issue opening directory select window on 64bit version.
- Several improvements to searching and fixed a rare issue with searching backwards with the wholeword option.
- Several improvements for high dpi screens.
Version 7.2 Build 732 - March 29, 2023
- New word multi-highlight feature (Off by default. Set in the Editor options.)
- Improved fonts and item spacing in ImpExpLite.
- Better import and export file encoding handling in ImpExpLite.
- Fixed an editor issue with non-breaking space characters.
- Fixed an issue where the SQL Formatter could stop working with certain options.
- Improved the SQL Formatter with complex queries.
Version 7.2 Build 730 - Jan 10, 2023
- Several minor editor improvements.
- Fix: Shift-Backspace now works as it did in Golden 6.
- Fix: Exports will no longer include a "No records" record if they are empty.
Version 7.2 Build 728 - Oct 29, 2022
- New feature: Automatically show blobs that contain pdfs, Word, or Excel documents in the native application.
This option is off by default and controlled by the "Show blob docs in native application" option on the DataGrid options page.
Double-click the cell or select it and choose "Show cell detail" to view the document. - Improved displaying large blobs as hex or text.
- Added more encodings to the cell detail window.
- Fixed an issue with using DESC in the 64bit version.
Version 7.2 Build 726 - Sept 28, 2022
- Improved datagrid selection colors.
- Added -t"tns_admin path" commandline option to set or override TNS_ADMIN.
Example: -t"C:\Oracle" - Added special tab coloring for any tab where the tabname starts and ends with a dash. This is useful as a spacer tab in workspaces.
- Fixed tabsize option not saving.
Version 7.2 Build 724 - May 24, 2022
- Improved BOM handling for UTF files.
- Updated editor shortcuts: Ctrl-Delete (delete next word), Shift-Ctrl-Delete (delete to line end)
- Updated editor shortcuts: Ctrl-Backspace (delete previous word), Shift-Ctrl-Backspace (delete to line beginning)
- Fixed a performance issue with replace all.
Version 7.2 Build 722 - April 7, 2022
- Tab display improvements.
- New improved tab text visibility especially in dark theme mode.
- New tab modified and busy indicators.
- Editor improvements
- New editor quality and performance improvements.
- New modernized selection color and display improvements.
- New change tracker indicators.
- New indent guide indicators.
- New separate bookmarks and line numbers options.
- Improved editor option choices on the view menu.
- Improved editor option choices on the options window.
- Fixes to undo issues with mixed tab characters.
- Theme and visual improvements for Windows 11 support.
- Find and replace improvements with better reporting and less prompting.
- Fixed tools menu PLEdit choice failing to start PLEdit7.
- Fixed AutoIndent option not working correctly when unchecked.
- New "Allow break during exec" advanced option.
- Case toggle now cycles through three options.
- ImpExpLite: Several changes to "Delete existing data" option including the ability to remove it.
Version 7.1 Build 718 - Aug 9, 2021
- Support for Oracle 21c.
- New Tab autosave feature.
- Find/Replace now saves state.
- LOB performance improvements.
- Default font to Consolas if it exists.
- Several highlighting improvements.
- Keyword adding/removing.
- Fixed some colors in dark mode.
- Fixed popup typing helper resizing in dark and light modes.
- Fixed a minor memory leak in Explain Plan.
- Improved ImpExp's progress indicator to be more accurate.
- Some popup typing improvements.
Version 7.1 Build 716 - May 4, 2021
- New feature: Bind variable prompting. To use it check "Prompt for bind variables" on the script options window or use the new "set bindprompting on/off" script command.
- Improved var command with direction for bind varibles: in/out/inout.
- Added new SQL menu choices for generating select, insert and update statements to the columns list of the SQLBuilder.
- Added "set transposed on/off" script command to set the grid's transposed mode.
- Fixed some text issues with the dark theme.
- Fixed a search and replace issue where characters could be skipped.
- Fixed an issue where a var refcursor showing in the grid wouldn't free properly if all bind vars were cleared.
Version 7.1 Build 714 - February 8, 2021
- Performance improvements when switching to transposed grid mode.
- Performance improvements for autosizing.
- Performance improvement to brace highlighting on huge scripts or scripts with thousands of braces.
- New high-dpi enabled datagrid sort buttons.
- Fixed DBMS_Output strings containing multiple lines showing on the same line.
- Fixed a key shortcut issue on keyboards that require a control key combo to type '*'
- Fixed an index error showing a scratch window of a transposed grid under certain conditions.
- Fixed an issue with replace all with the up option and recursive values.
Version 7.1 Build 712 - September 15, 2020
- Improved the cell detail window for blobs. Blob fields are checked for image formats and displayed as images if possible with a default of displaying non-image blobs as text (instead of the older default of a hex display.)
- Added single and multipage tiff support to the blob image display window.
- Added "append" as an option to script csv and delimited exports. This allows exporting from multiple queries to the same csv file (appended exports should use the NOHEADERS option.)
- Var statements can now include an assignment (e.g. var MyVar string = "benthic";)
- The scratch window has been updated to correctly show the optional null indicator.
- Visual and performance improvements while loading large workspaces.
- Updated Unicode file encoding options including improved UTF-8 file detection.
- Fixed the beginning and end of line caret left/right wrapping behavior to work like Golden 6.
- Added "Reverse home key behavior" option to the editor options page.
Version 7.1 Build 710 - May 26, 2020
- New blob image display. Double click or view cell details on an image blob to view the image, plus zoom and copy to clipboard.
- Many improvements to the visual appearance including grid fixed border colors, splitter bars and toolbar backgrounds.
- While editing you can paste a file into a blob field to load it to the database. You can also use Shift-F2 to choose a file.
- Switching between themes will no longer clear the data grid.
- Row indicators and edit markers are now high dpi aware and will scale with selected grid font size.
- Row indicators and edit markers are now shown in white when used with the dark theme.
- Tab background colors for current tabs should show more of a contrast.
- Fixed missing Alt hotkey markers on main menus.
- Removed extra "Transpose" option from the grid's popup menu.
- Fixed a minor display issue when attempting to edit read only fields.
- Fixed an issue where language copy options weren't saved.
- Fixed an issue where the SQLBuilder wouldn't autosize text items properly.
Version 7.0 Build 707 - May 3, 2020
- Improved speed of transpose mode for huge datasets.
- Added new "Export blob field to file" option on the Results menu and the data grid's right click export menu.
- Fixed moving columns and then using transpose mode.
- Fixed performance issue with ImpExpLite and importing data.
- Fixed a parsing problem with "run selected text" and local commands.
Version 7.0 Build 706 - March 29, 2020
- Fixed script "Run options" menu options not checking and unchecking.
- Fixed tab caption display being too light using dark theme and colored tabs.
- Fixed issue where grid state wouldn't be correctly restored when scrolled to the far right and "Autosize" was enabled.
- Fixed issue with multiline scripts containing @ or start statements with leading whitespace.
- Fixed double quoted strings syntax highlighting.
- Improved: Changed datagrid headers right click menu to include all options.
- Improved: Favorites menu is now loaded in a background thread, speeding startup especially for mapped/network drives.
- Improved: Significant speed improvement for large "ExcelFile" exports.
- Improved: Several additions to keyword list.
Version 7.0 Build 705 - February 18, 2020
- Changed the editor caret behavior when clicking below the bottom line to match the Golden 6.x behavior.
- The DBMS_Output window will now remember its position when put on a different monitor than the main window.
Version 7.0 Build 704 - January 9, 2020
- Added "Export to Excel File" quick export option to the Results menu.
- Fixed tab icons and view area icon to correctly support High DPI displays.
- Fixed Replace All when used with the "Across Tabs" option.
- Fixed an issue with keyboard shortcuts using certain international keys.
- Fixed an issue where keyboard shortcuts set to None were not being saved.
- Fixed an issue with "toggle case of selection" when there was no selection.
- Fixed a Tool menu issue with 64bit versions.
- Fixed ROWID column not being shown in certain non-editing cases.
Version 7.0 Build 700 - December 2, 2019
- Improved user experience with larger fonts and icons.
- Improved support for high resolution displays.
- Light and Dark themes.
- Toolbar icon size options.
- Improved find and replace windows with support for regular expressions.
- Improved SQL typing helpers.
- Improved advanced export window.
- Improved and reorganized options window.
- New faster editor with improved editing features.
- Improved syntax highlighter.
- More robust q-quote parsing and highlighting.
- Support for the latest versions of Oracle, including 19c.
- Improved help system.
- Separate recent files and workspaces lists.
- Jumplist support.
- Customizing of program Shortcuts/Hotkeys.
- Improved installer with digitally signed uninstall.
This website uses cookies to enhance your browsing experience and analyze our website traffic and performance. By using this website, you agree to our use of cookies. Learn more about our Cookie Policy in our Privacy Statement.