Version 20 of Oracle

Updated 2013-09-08 19:06:38 by pooryorick

Oracle Corporation is the home page for Oracle Corporation, one of the leaders in the RDBMS field.

Description

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...

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.

Tcl Bindings

SQL Relay
OraTcl

Documentation

See Oracle Documentation

Reading

BOOK Oracle and Open Source

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]

 What: C-Forge IDE
 Where: http://www.codeforge.com/
        http://www.codeforge.com/linux/download.html
 Description: Multi-user integrated development environment with
        full project management, edit/compile/debug cycle support,
        abstraction of the makefile concept, and support for
        Ada, assembler, C/C++, FORTRAN, Java, Modula-2, Oracle ProC/C++,
        Objective C, Pascal, Perl, PHP, Python, Qt, and Tcl.
        Both a free and commercial version of this product is available.
        Available on Linux Intel and Alpha platforms, as well as DEC Tru64
        and AIX.  The latest version is 2.0 .
 Updated: 04/1999
 Contact: mailto:[email protected]

 What: datavision
 Where: ftp://ftp.procplace.com/pub/tcl/sorted/packages-7.6/graphics/dv1.0b/dv1.0b.tar.gz
 Description: DataVision is a window surfaced table plotting program
        based on Tcl 7.3/Tk 3.6/tclX.  Supports 2-D diagrams.  Has been
        tested with Windowing Oracle SQL (wosql) v2.2 as well.
 Updated: 02/1997
 Contact: mailto:[email protected] (Michael Boese)

 What: ODDIS (Oracle Data Dictionary Information System)
 Where: ftp://ftp.informatik.uni-hannover.de/software/oddis-2.11.tar.gz
 Description: ODDIS shows most of the static information about the Oracle
        V7 Data Dictionary.  When you click on a database object,
        the tool displays detailed information about it in a formatted
        output window.  One can perform ANALYZE, EXPLAIN and other
        SQL commands in a gui window.  One can create tables with
        information about physical devices.  One can see constraints
        and comments.  Execution of PL/SQL blocks is now supported.
        Display of user lists, all objects, free space summaries,
        tablespaces, rollback segments, data files, roles, etc. are
        available.
 Contact: mailto:[email protected] (ODDIS team)

 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

What: debbie

 Where: http://www.davudsplace.net/debbie1.html
 Description: Oracle database extension with a Tclish orientation;
        contact indicates that it might be able to be abstracted for use
        with other DBMS.
 Updated: 09/2000
 Contact: mailto:[email protected]

 What: nstcl
 Where: http://michael.cleverly.com/aolserver/nstcl
 Description: Tcl package that implements the AOLserver's ns_db API.
        The current version supports Oracle 8 (by wrapping calls to Oratcl
        3.0),  Postgres 7 (via pgtclsh), and Solid (via  Soltcl).
        The current version (as of August 1, 2000) is 0.3
 Updated: 08/2000
 Contact: mailto:[email protected] (Michael A. Cleverly)

oratcl

 What: Oracle extension to Tcl.
 Where: http://oratcl.sourceforge.net/
        http://sourceforge.net/projects/oratcl/
        ftp://ftp.procplace.com/pub/tcl/sorted/packages-7.6/databases/oratcl-2.5/oratcl-2.5.tar.gz
        ftp://ftp.procplace.com/pub/tcl/sorted/packages-8.0/distrib/cvs-oratcl.tar.gz
        http://people.a2000.nl/hkooiman/Oratcl
        http://technet.oracle.com/
 Description: Provide access to a Oracle (versions through 6-11g) Database
        server from within Tcl.  OraTcl 3 and up supports Tcl 8
         (tclX recommended), and supports Tcl 8.x, includes Windows NT DLLs,
        cursor variables from PL/SQL, can bind Tcl variables to
        orafetch results, can bind Tcl variables to Oracle :bind variables,
        supports asynchronous SQL execution.
        It supports Tcl/Tk 8.x, Oracle 7/8/8i/9i/10g/11g, i18n data, and TEA/Stubs as
        well as Solaris and Windows NT.
        OraTcl 2.5 was the last version to support Tcl 7.6.
        The a2000 site has information relating to a Macintosh port of
         Oratcl.  Oracle has released a version of its 8.0.5
         database product for Linux at the oracle web site.
        Currently the version is 4.4 .
 Updated: 09/2001
 Contact: mailto:[email protected] (Todd M. Helfter)
        mailto:[email protected] (Tom Poindexter)

 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)