Oracle

Oracle Corporation, a leader in the RDBMS field, is one of the two largest software companies in the world (like the other, Microsoft, a small fraction of its revenue comes from hardware product sales). Oracle has a corporate reputation for being combative, high-priced, enterprise-oriented, aggressive in its sales orientation to the point of occasional criminal investigation, and generally successful.

Tcl Bindings

SQL Relay
OraTcl
nstcl

Documentation

See Oracle Documentation

Reading

BOOK Oracle and Open Source

Description

Oracle itself is a major user of Tcl. Several administrative utilities are Tk products. Oracle Enterprise Manager is crucial to ...

... Oracle Intelligent Agent ... Oracle Trace ...

LV: Note that Oracle is now at version 11. Somewhere around version 10, they quit shipping a tcl component, but apparently still have some vestiges of tcl references in some of the materials. This is going to go away...

OMB Plus is a flexible, high-level command line metadata access tool for Oracle Warehouse Builder. OMB Plus is an extension of the Tcl programming language.

Transaction Control Language?

escargo 2007-08-21: The issue is muddied somewhat because Oracle also has a Transaction Control Language (so it's also abbreviated as TCL). (See http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28370/static.htm#BABICCHJ).

EMJ Well, no it doesn't, really. That reference is only a short note about the statements used to control transactions in SQL or PL/SQL, i.e. transaction control language with no capitals! There is no specific language involved. I consider the section heading Transaction Control Language (TCL) Statements to be a documentation bug and I intend to raise it as such - the abbreviation should not be there. This is the only such use of it in the entire Oracle documentation set.

escargo: I certainly don't mind if it's clarified, but searching through Oracle on-line docs for the right Tcl gets just a little harder when there is a clash like that.

Software using Oracle

In Tcl FAQ, part 4:

 What: ArsDigita Community System
 Where: http://openacs.com/
        http://arsdigita.com/
        http://arsdigita.com/free-tools/oracle-driver.html
        http://www.arsdigita.com/bboard/q-and-a?topic%5fid=21&topic=web%2fdb
        http://www.arsdigita.com/acs-repository/
        http://dev.arsdigita.com/acs40/ldap-authentication.html
        http://software.arsdigita.com/
        http://photo.net/doc/
        http://photo.net/wtr/thebook/community.html
        http://acspg.benadida.com/
        http://www.ybos.net/
        http://larsdigita.com/software/ldap-in-general.html
        http://larsdigita.com/tmp/adldap.tgz
 Description: An AOLserver/ORACLE based Tcl web application that provides
        users with forums and other web based applications.
        The ArsDigita Community System (ACS) is an database backed web
         collaboration tool originally written for Oracle and also ported
         to InterBase DBMS, release 4.0, available on Linux at no charge.
        ACS operates on top of AOLServer, a free HTTP server.
        Now includes the source for the Oracle driver as well as the
         nscache, nsrewrite, and nssha1 modules.
        Source is available and binaries for Redhat Linux and Solaris
         are available.  A Windows version is being developed.
        Information regarding exporting of Tcl wrappers for OpenLDAP compliant
         libraries is available on arsdigita, with more info and code on
         larsdigita.
        The Ybos web page has new ArsDigita modules for group scoping,
         event planning and content management.
        A version based on PostgreSQL is available at benadida.
        ArsDigita has their own release of AOLserver (v3.2+ad10),
         as well as Oracle drivers, etc.  See the acs-repository URL.
        Recently ArsDigita moved to a Java based distribution.  However, the
         OpenACS project took over the Tcl based software from what
         I understand.  OpenACS is at version 3.2.5 with a version 4 b2 in
         testing.
 Updated: 06/2001
 Contact: mailto:[email protected]
C-Forge
Datavision
ODDIS
 What: Oracle wrap for Tcl/Tk
 Where: ftp://ftp.cad.gatech.edu/pub/tk/oracle.tar.Z
 Description: A simple ORACLE wrap that implements SQL commands in Tcl/Tk.
 Contact: mailto:[email protected] (Mark Andrew Hale)

 What: Sibylla
 Where: http://www.cib.unibo.it/guests/ariadne/sibylla/
 Description: An application development framework for WWW based applications.
        Sibylla allows access to data stored in databases, indexed HTML
        files, or, in general to data management by a server-side application.
        Sibylla 2.0 supports BasisPlus, Informix, Ingres, Microsoft SQL
        Server, mSQL, Oracle, and Sybase.  The WWW interface module for
        Sibylla is free.  The various database modules have varying prices
        depending on the database.  See the WWW site for details.
 Updated: 11/1996
 Contact: mailto:[email protected] (Ing. M.Ricotti)

 What: StepTool
 Where: ftp://ce-toolkit.crd.ge.com/pub/tcl/step_tool.tar.Z
 Description: Lockheed Martin tracking software for development and test
        results of software systems.  Uses Oracle.
 Updated: 08/1998
 Contact: Unknown

Extensions

and http://www.purl.org/NET/Tcl-FAQ/part5.html

debbie
 What: RDB extension
 Where: ftp://ccfadm.eeg.ccf.org/pub/ctk/rdb.tar.Z
 Description: Tcl extension for the portable Relational Database Package.
        Based loosely on DBperl.  Can support modules such as informix,
        oracle, ingres, etc. but only provides informix.
 Updated: 11/1996
 Contact: mailto:[email protected] (Martin Andrews)

 What: Tk login window
 Where: http://ftp.res.bbsrc.ac.uk/pub/tcl-tk/login.tcl
        http://ftp.res.bbsrc.ac.uk/pub/tcl-tk/password.tcl
 Description: A Login and Password proc for logging into ORACLE.  Could
        be adapted for other types of login needs.
 Updated:
 Contact: mailto:[email protected] (Andy Caiger)

 What: Explain
 Where: http://www.cpan.org/authors/id/ABURLISON/Explain-1.0.tar.gz
 Description: GUI tool to enable visualizing Oracle Query plans.
        Requires perl, DBI/DBD::Oracle and Tk 8.
 Updated: 03/1999
 Contact: mailto:[email protected] (Alan Burlison)

 What: Orac
 Where: ftp://ftp.funet.fi/pub/languages/perl/CPAN/authors/id/A/AN/ANDYDUNC/
 Description: pTk extension and program integrating databases and Perl/Tk.
        Requires perl 5.005_02, DBI-1.13, Tk800.015, relevant DBD drivers.
        Works with Oracle, Informix, Sybase, etc. Currently at v1-1-31.
 Updated: 09/1999
 Contact: mailto:[email protected] (Andy Duncan)

See: HammerDB


ASHMON uses Oracle's Active Session History feature to provide detailed performance analysis. Updates: [1].

http://www.perfvision.com/ashmon/ashmon161107.png