Golden 是一個特設的查詢工具,有許多強大的功能。它具有密切的兼容性SQLPLus’腳本公約,包括變量提示和腳本參數傳遞。這是一個 32位多線程應用程序,允許多個腳本進行編輯,並同時運行。這是優化資源,可以快速和容易上守。一些突出的特點是:
- 支持的客戶端操作系統:Windows XP及更高版本,包括Terminal Server/Citrix.
- 支持Oracle 8及更高版本,包括Oracle 19c。Requires a working Oracle Client, full or instant.
- 完全的Unicode支持
- 客戶端排序和過濾
- 將資料導出成不同檔案格式,包括CSV, Delimited, XML,和HTML.
- 透過COM自動化技術導出Excel和Open Office Calc。也可以直接導出Excel xls和xlsx文件檔。匯出時可編寫script並使用命令行選項使script自動運行。
- 可定制的工具欄
- 編輯並同時運行多個腳本
- 支持SQLPlus variable prompting, bind variables (including RefCursor), and calling external scripts with parameter passing.
- 支持EXEC, DESC 和 CONNECT
- 支持DBMS輸出
- 腳本和發言時間
- 解釋計劃輸出
- 支持SQLPlus style SPOOL files
- 編輯單個表的結果集
- 強調彩色語法
- 架構信息粘貼到腳本和查詢
- 語言特定的剪切和粘貼粘貼查詢到Delphi, VB, ASP, Java, C++, etc.
- 一個複雜的ASCII導入 /導出,可以處理數百萬的記錄。
GoldView
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.
- Supported Client Operating systems: Windows XP, Vista, Windows 7, Windows 8, Terminal Server/Citrix, 64bit (with 32bit Oracle Client Installed.)
- Supports Oracle 8.0 - 12, SQLNet 2.x - Net12 (including 'Instant Client')
- Displays objects in all accessible schemas
- Colored syntax highlighting
- Full Unicode support
- Displays objects in all accessible schemas
- Show 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!
PLEdit
PLEdit allows editing and compiling of PL/SQL code modules (stored procedures.) It is optimized to be quick and resource friendly.
- Supported Client Operating systems: Windows 10, Windows XP, Vista, Windows 7, Windows 8, Terminal Server/Citrix, 32 and 64bit.
- Supports Oracle 8.0 - 12, SQLNet 1.x - Net12 (including 'Instant Client')
- Edit multiple modules simultaneously
- Supports Oracle 10's new compile warnings and hints feature
- Places the cursor right on any errors found
- Colored syntax highlighting
- Schema information for pasting into modules
- Manage your stored procedures
- Show dependencies visually
- Export all Schema modules to disk
BenthicSQALL
BenthicSQALL is an SQL query tool that works with any database with an ODBC or OLEDB driver. This includes Oracle, DB2, Sql Server, Sybase, MySQL, Firebird and many others.
- Supported Client Operating systems: Windows 10, Windows XP, Vista, Windows 7, Windows 8, Terminal Server/Citrix, 32 and 64 bit versions
- Supports any database with a 32 or 64 bit ODBC or OLEDB driver
- Full Unicode support
- Tabbed interface including Workspaces
- Syntax highlighting SQL editor
- SQL Builder showing schema information
- Built in SQL Formatter
- Client side sorting
- Export data to different file formats including CSV, delimited, XML, and HTML
- Export to Excel and Open Office Calc through COM automation. Also export directly to Excel xls and xlsx files. Exports can be scripted and run automatically using command line options.
- Ability to export data to a script of SQL insert statements
- Ability to spool results to a text file and/or text pane
- Direct editing of query results (if supported by driver)
- Ability to run stored procedures (if supported by driver)
- Support for SQL Bind variables
- Support for prompt variables to make your SQL statements and scripts interactive
- Language specific cut and paste for pasting queries into Delphi, VB, ASP, Java, C++, PHP, etc.