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.
- TSHSQL – DB Navigator (Windows)
- TSHSQL – DB Navigator (Metal)
- TSHSQL – DB Navigator (Motif)
- TSHSQL – SQL Query (Grid)
- TSHSQL – SQL Query (Text)
- TSHSQL – SQL Query (XML)
- TSHSQL – SQL Query (HTML)
- TSHSQL – SQL Query (Config)
- TSHSQL – Code Editor
- TSHSQL – Describe
- TSHSQL – Show DDL
- TSHSQL – Backup
- TSHSQL – DB Performance Overview
- TSHSQL – AWR Reports (10g)
- TSHSQL – ADDM Reports (10g)
- TSHSQL – AWR Trend Graphs (10g)
- TSHSQL – DB Performance Overview
- TSHSQL – DB Session Monitor
- 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:
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.
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)
Includes: Addition of a screen to display graphs of AWR trends in Oracle 10g.
Includes: Addition of screens to display AWR and ADDM reports in Oracle 10g.
Includes: Amendments to most existing navigator queries and additional monitoring queries. Substantial additions to the DB Session Monitor screen.
Includes: Minor bug fixes.
Includes: Top SQL, improved menu structure, multi-line comment syntax highlighting in PL/SQL and Java.
Includes: DB Performance Overview, DB Session Monitor and additional navigator features.
Includes: Additional navigator functionality including extra generate options.
Includes: Improved thread management for Export, Import and SQL*Loader utilities. New XML and HTML query output formats. Syntax highlighting for Java Stored Procedures.
Includes: Additional types of backup script and improvements to Show DDL.
Includes: Support for the Export, Import and SQL*Loader utilities. Addition of a backup script generator and bug-fixes.
Includes: Additional editing features, syntax highlighting and bug-fixes.
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.