(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
Author: SSWUG Research
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.
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
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
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
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
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.
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
Declaration of bind variables
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
Encrypting Data Values in DB2® Universal Database
(Bruce Benfield and Richard Swagerman) This paper describes how to use new functions available in IBM DB2 Universal Database Version 7.2 (Unix & Windows) to easily integrate data encryption into database applications. For years, databases have been able to keep unauthorized persons from being able t