商品明細

Golden 資料庫開發

商品簡述
Golden是Oracle資料庫的查詢工具,它包括高級查詢功能、數據編輯和強大的導入和導出功能

商品介紹

本產品出貨為最新版本。
如需購買或了解內容請來電(2749-1909)或來信(
sales@ahasoft.com.tw)業務部
___________________________________________________________________

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 XP and above including Terminal Server/Citrix.
  • upports Oracle 8 and above, including Oracle 21c. Requires a working Oracle Client, full or instant.
  • ull Unicode support.
  • Client side sorting and filtering.
  • 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.
  • Customizable Toolbars.
  • Edit and run multiple scripts simultaneously.
  • 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.
  • Explain Plan output.
  • Support for SQLPlus style SPOOL files.
  • Editing of query results with full transaction control.
  • Colored syntax highlighting.
  • Schema information for pasting into scripts and queries.
  • Language specific cut and paste for pasting queries into Delphi, VB, ASP, Java, C++, PHP, etc.
  • A sophisticated separate import/export application (ImpExpLite) that can handle millions of records.​​​​​

Remote/Home use tips

All of our products work very well in a remote "working from home" environment. Our Oracle specific products have no other dependencies beyond a working Oracle Client. This blog post outlines installing on a home machine and includes several tips for usage that will increase performance on metered or low bandwith connections. The following instructions and tips apply to Golden as well as all of our Oracle products.

Installing Golden and the Oracle Client

Golden and the Oracle Client can be installed in any order, but the client must be installed and configured before using Golden. We recommend using the Oracle Instant client as it is very easy to install and can be used with no additional configuration at all in most cases.

1. Download and unzip the Oracle Instant Client into a local directory. Golden just needs the basic or basic-light installs depending on what languages are needed.

2. Download and install Golden (or any of our products.) If you're using the 32bit Oracle Cient use the 32bit version of Golden. Use the 64bit version of Golden if you're using the 64bit Oracle Client.

3. Start Golden and at the login window click "Login Options..."

4. On the Login Options window enter the location of your Oracle Client's OCI.DLL file into the 'Oracle Client DLL' field.

golden oci path


5. Click ok to save your settings.

6. On the login window enter your username, password and the database information. Using the instant client this can be an EZConnect entry which looks like '//servername|serverip#/sid'

7. Alternately if you'd like to use a tnsnames.ora file you should use oracle's TNS_ADMIN environment variable to set the location of your tnsnames.ora file.

Golden tips for speed and saving bandwidth

Whenever running a script or query it's a good idea to limit the size of the result set to just what you need. This can be done using standard where clause conditions to constrain the data returned, or you can use ROWNUM or the FETCH clause (Oracle 12+) to limit your results.

1. Turn off "download blobs" on the advanced options page. This setting is off by default.

2. Turn off typing popup helpers on the Editor page of the options window.

3. Set the Column Information setting of the SQLBuilder to "Columns Only"

4. Limit query results using appropriate where clause settings.

5. Use ROWNUM or the FETCH clause (Oracle 12+) to limit or page results.
Golden can also limit result sets using the "limit select results" option on the advanced options page.