Populating Master-Detail Foreign Key Values Using Sequences - This article presents some safe methods for populating master-detail foreign key columns when using sequences.

RANK, DENSE_RANK, FIRST and LAST Analytic Functions - Simple examples of how to use these analytic functions.

Regular Expression Support in Oracle (REGEXP_COUNT, REGEXP_INSTR, REGEXP_REPLACE, REGEXP_SUBSTR, REGEXP_LIKE) - Using regular expressions to solve some questions I've been asked over the years.

Retrieving HTML and Binaries into Tables Over HTTP - This article gives two brief examples of how HTML pages and Binaries, such as images or documents, can be downloaded over HTTP and placed directly into tables.

ROLLUP, CUBE, GROUPING Functions and GROUPING SETS - An overview of some functionality available for aggregation in data warehouses.

ROWIDs for PL/SQL Performance - This article demonstrates how using ROWIDs in transactions can improve performance.

Short-Circuit eva luation in PL/SQL - This article describes how short-circuit eva luation can be used to improve the performance of some boolean expressions.

SQL/XML (SQLX) : Generating XML using SQL - Oracle9i Release 2 includes functionality to support the emerging SQL/XML standard to simplify XML generation from SQL queries.

String Aggregation Techniques - Several methods of combining multiple rows of data into a single row using aggregate functions.

Top-N Queries - Top-N queries provide a method for limiting the number of rows returned from ordered sets of data.

Using Ref Cursors To Return Recordsets - Return recordsets from Oracle stored procedures.

UTL_HTTP and SSL (HTTPS) using Oracle Wallets - This article describes how to use the UTL_HTTP package to interact with resources secured by SSL (HTTPS).

Web Scripting for Oracle (PHP, Perl, JSP, ASP and ASP.NET) - This article presents the basic syntax for several popular web scripting languages that connect to Oracle databases.

WITH Clause - Use the WITH clause to reduce repetition and simplify complex SQL statements.

XML-Over-HTTP (REST Web Services) From PL/SQL - XML-over-HTTP was the precursor to web services allowing easy access to XML via HTTP GETs and POSTs.

Middleware

Oracle 9iAS Articles - Installation and configuration articles for Oracle 9iAS.

Oracle AS10g Articles - Installation and configuration articles for Oracle AS10g.

Oracle WebLogic 11g Articles - Installation and configuration articles for Oracle WebLogic 11g.

Oracle WebLogic 12c Articles - Installation and configuration articles for Oracle WebLogic 12c.

An Oracle DBA's Guide to WebLogic Server - An overview of WebLogic Server for beginners, especially DBA's, who are new to middle tier administration.

Linux HTTP Server Configuration - Install and configure an Apache HTTP server on Linux.

Apache Tomcat Installation on Linux - A guide to installation of Apache Tomcat on RHEL and its clones.

Apache Tomcat 7 Installation on Windows - A guide to installation of Apache Tomcat 7 on Windows.

Apache : Reverse Proxy Configuration - Learn how to configure Apache as a reverse proxy server.

Apache Monitoring using mod_status (server-status) - Monitor the performance of Apache servers using the mod_status Apache module.

Signing JAR Files - This article describes the method for creating a keystore and signing JAR files.