ORACLE-BASE – TSHSQL – PL/SQL editor and SQL query tool

ORACLE-BASE – TSHSQL – PL/SQL editor and SQL query tool


TSHSQL – PL/SQL Editor and SQL Query Tool

TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java 1.4 JRE (and an Oracle client installation for full OCI support). It is designed to take advantage of Oracle 9i and 10g features but most functionality is compliant with Oracle8i also.


Screen Shots


Installation

  • Download and install Java JRE 1.4.
  • Download the TSHSQL-V112.zip file and unzip its contents to a directory of your choice.
  • Copy the following Oracle supplied files to the same directory as the TSHSQL jar files:
    $ORACLE_HOME/jdbc/lib/classes12.jar
    $ORACLE_HOME/lib/xmlparserv2.jar
    If you cannot find these files download the OracleSupportFiles.zip file and unzip its contents to the same directory as the TSHSQL jar files.
  • Amend the TSHSQL.conf file specifying:
    The version of the Oracle JDBC driver you wish to use. The version you use depends on the version of the Oracle client software you have loaded on your machine. For best results use the appropriate “oci” option:
    oci8 – Oracle8i client using classes12.jar copied from client installation.
    oci – Oracle 9i or 10g client using classes12.jar copied from client installation or downloaded support files for version 9.2.0.
    thin – No Oracle client loaded. This option is slower and does not support all features.

    The owner and name of the plan table used to create execution plans.

    The ORACLE_HOME on the client machine if present. Some features will not work correctly without this setting.

    Windows users can specify the SQL*Plus executable name which can vary depending on the version (sqlplusw.exe).

  • Amend the contents of the startup files as appropriate, making sure the path to the JRE is correct. The NT/2000 file (StartTSHSQL.bat) may no be required if the JRE is properly registered as the application can be started by double-clicking on the TSHSQL.jar file. The UNIX/Linux file (StartTSHSQL) also needs some Oracle paths defined if the “oci” or “oci8” driver is used.
  • Execute the start file and begin using TSHSQL.


Download Files

  • TSHSQL-V112.zip
    Includes: Additional queries added to navigator tree.
  • OracleSupportFiles.zip (only use these if you do not have a local copy of classes12.jar and xmlparserv2.jar files)


Archives

  • TSHSQL-V111.zip
    Includes: Addition of a screen to display graphs of AWR trends in Oracle 10g.
  • TSHSQL-V110.zip
    Includes: Addition of screens to display AWR and ADDM reports in Oracle 10g.
  • TSHSQL-V109.zip
    Includes: Amendments to most existing navigator queries and additional monitoring queries. Substantial additions to the DB Session Monitor screen.
  • TSHSQL-V108.zip
    Includes: Minor bug fixes.
  • TSHSQL-V107.zip
    Includes: Top SQL, improved menu structure, multi-line comment syntax highlighting in PL/SQL and Java.
  • TSHSQL-V106.zip
    Includes: DB Performance Overview, DB Session Monitor and additional navigator features.
  • TSHSQL-V105.zip
    Includes: Additional navigator functionality including extra generate options.
  • TSHSQL-V104.zip
    Includes: Improved thread management for Export, Import and SQL*Loader utilities. New XML and HTML query output formats. Syntax highlighting for Java Stored Procedures.
  • TSHSQL-V103.zip
    Includes: Additional types of backup script and improvements to Show DDL.
  • TSHSQL-V102.zip
    Includes: Support for the Export, Import and SQL*Loader utilities. Addition of a backup script generator and bug-fixes.
  • TSHSQL-V101.zip
    Includes: Additional editing features, syntax highlighting and bug-fixes.
  • TSHSQL-V100.zip


Support

This is a free product and there are no guarantees that it will be upgraded or supported. If you have any questions you can post them on the TSHSQL forum, but remember, no guarantees.

Regards Tim…

Back to the Top.

Tinggalkan Balasan

Please log in using one of these methods to post your comment:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s