This section explains in detail how to declare bind variables in the otl_stream. A SQL statement, PL/SQL block or a stored procedure call may have placeholders which are usually connected with bind variables in the program. OTL 4.0 has a small parser that parses the SQL statament / PL/SQL block
Other News
Generating XML from SQL Server database
(Peter Bosch) This sample shows how you can obtain a Dataset from (in this case) a SQL Server database, and then write it out to an XML Document. As an “Extra Added Bonus(tm)”, it can show you how to write the schema as well. The SQL Server database in question is the venerable and useful Northwind
Using Hierarchical Data in XML
This is a quick code example of building out a hierarchical data tree with XML. The example includes schema, data and display examples to show how the information is structured. Also includes JavaScript showing how to work with the data.
Create XML by using MySQL and PHP
(Mike Britton) PHP is a scripting environment that allows you to work with XML. Here’s how to use open source tools such as PHP and MySQL to manipulate XML. XML has emerged as a standard for data exchange. Java and .NET both include inherent XML support, but developers outside of these environme
Gbrowse for Oracle, PostgreSQL, and BioSQL
Generic Genome Browser – support for various databases and database schemas are coming. Right now, there is full support for the Bio::DB::GFF schema running on MySQL, preliminary support for the Bio::DB::GFF schema running on top of Oracle, preliminary support for the Bio::DB::GFF schema running on
Administering Real Application Clusters Databases with Oracle Enterprise Manager
This chapter describes how to use Oracle Enterprise Manager to administer Real Application Clusters databases. This chapter only describes Oracle Enterprise Manager administration for Real Application Clusters. Use this section as a supplement to information in the Oracle Enterprise Manager Administ
Valid SQL-JDBC Datatype Mappings
This chapter, from the online reference guide, contains detailed JDBC reference information, including the following topics: – Valid SQL-JDBC Datatype Mappings – Supported SQL and PL/SQL Datatypes – Embedded SQL92 Syntax – Oracle JDBC Notes and Limitations – Related Information
A tutorial about using and creating JOINS and UNIONs
This site outlines in excellent detail how you create and use Joins. From inner joins to outer joins and unions, each option is explained and outlined. While the site focuses on SQL Server, additional tips and information are provided for other platforms where possible.
sp_JRMCrossTab – a crosstab query script
(John MacIntyre) When I needed a pivot table or Crosstab type of view in SQLServer, I was disapointed to not find anything resembling the MS Access Crosstab query. There are tools available, but I didn’t want to pay the kind of money they were asking and felt it necessary to learn how to do this mys
DB2 Basics: Fun with Dates and Times
(Paul Yip) This short article is intended for those who are new to DB2 UDB and wish to understand how to manipulate dates and times. Most people who have worked with other databases are pleasantly surprised by how easy it is in DB2 UDB.