Technical Articles for Developers (2006 and newer)

 Business Intelligence
 Cloud Computing & Google
 Java & Frameworks
 Middleware & SOA (see Articles for Architects)
 .NET
 PHP, Python, Ruby & Open Source
 SQL & PL/SQL
 Testing & Performance

See articles published in 2005 and older | See java.sun.com articles | See Dev2Dev & Arch2Arch archives | Back to Articles home

Business Intelligence

See also BI & Data Warehousing Technology Center

Oracle Essbase Studio Deep-Dive [Mar 2010]
by Christian Screen
Dive into a step-by-step tutorial that reflects real-world data warehousing complexities.

Building a Cube [01-Jan-2010]
by Tracy McMullen and Edward Roske
Learn the basics of building an Oracle Essbase aggregate storage database.

Getting Started with BI Publisher ToolBox [28-Oct-2009]
by Ike Wiggins
Learn how this free utility can make running Oracle BI Publisher reporting components incredibly easy.

Developing a Knowledge Module in Oracle Data Integrator [8-June-2009]
by Uli Bethke
Uli Bethke teaches you how to build your very own Integration Knowledge Module for fast time-to-production in data integration design.

Managing Your Oracle Business Intelligence Infrastructure using the Oracle Enterprise Manager 10 g Rel 4 BI Management Pack [10-Feb-2009]
by Mark Rittman
You can now manage business intelligence services in the same centralized way that you manage the rest of your Oracle, and non-Oracle, estate.

Integrating Oracle's Hyperion Essbase - System 9 with Oracle Business Intelligence [16-May-2008]
by Mark Rittman
A step-by-step guide to using Oracle's Hyperion Essbase – System 9 as a back end for Oracle Business Intelligence Suite Enterprise Edition. From Oracle ACE Director Mark Rittman.

Integrating Oracle Business Intelligence Enterprise Edition Plus with SOA [26-Feb-2008]
by Mark Rittman
A detailed look at the integration possibilities between Oracle SOA Suite and Oracle Business Intelligence Enterprise Edition Plus, from Oracle ACE Director Mark Rittman.

Intelligence and Identity [01-Jan-2008]
by Mark Rittman and Joel Crisp
Integrating Oracle Business Intelligence and Oracle Identity Management.

Reporting with the Familiar [21-Jun-2007]
by Mark Rittman
Create reports with familiar desktop tools and Oracle enterprise datasources.

Decisions Grow on Trees [01-Mar-2007]
by Ron Hardman
Oracle Data Miner decision trees classify and analyze data.

Using the Oracle Data Mining API [01-Aug-2006]
by Agust Egilsson
Learn how to safely let end users access Oracle's analytic APIs directly via a spreadsheet interface built with Oracle JDeveloper.

Learn and Predict [01-Mar-2006]
by Ron Hardman
Explain your data and explore results, using predictive analytics.

Back to Top

Cloud Computing & Google

Creating Prebundled Machine Images for the Cloud [20-Nov-2009]
by Kiran C. Nair
Learn how to create a custom virtual machine image prebundled with Oracle WebLogic Server 11g and Oracle Database XE, as well as the basics of creating init scripts and configuring services to run at user-defined runlevels.

Building Applications in the Cloud [19-Aug-2009]
by David Peake
Combine Oracle Application Express and Amazon EC2.

Running Oracle Database XE in the Cloud [23-Sept-2008]
by Justin Lokitz
Learn how to build and deploy Oracle Database 10g Express Edition virtual images in the Amazon Elastic Compute Cloud—the "do-it-yourself" way.

Mashing Google Maps with Oracle Database [28-Aug-2007]
by Chris Schalk
Easily build a mashup application that integrates Oracle data with the Google Maps API using Oracle XML DB.

Introduction to the Google Web Toolkit [1-Oct-2006]
by Julien Dubois
Learn how to use the Google Web Toolkit to do everything from basic tasks to advanced ones such as RPC communication, history management, and packaging a production-ready application.

Back to Top

Java & Frameworks

See also: java.sun.com articles | Dev2Dev archives | Java Developer Center

Accelerating Multimedia Application Development with JSR 309 Media Server Control API [Apr 2010]
by Marc Brandt, Tomas Ericson, and Alain Comment
Learn how to build a SIP Servlet conferencing application using the JSR 309 Reference Implementation Driver running in Oracle Communications Converged Application Server and accessing the HP OpenCall Media Platform.

Oracle ADF Essentials - Continuous Integration with Hudson [Feb 2010]
by John Stegeman
The basics of installing and configuring the Hudson integration engine to continuously build and test Oracle ADF applications

Joining Oracle Complex Event Processing and J2ME to React to Location and Positioning Events [Mar 2010]
by Daniel Amadei
How to join the power of the Location API for J2ME (JSR 179) with Oracle Complex Event Processing to deliver business applications that can't be built without an event processing tool.

Oracle ADF Essentials - Continuous Integration with Hudson [Feb 2010]
by John Stegeman
The basics of installing and configuring the Hudson integration engine to continuously build and test Oracle ADF applications

Oracle ADF Essentials - Testing with Selenium [Feb 2010]
by John Stegeman
How to use Selenium and JUnit together to build unit tests that test Web UIs.

Oracle ADF Essentials - Unit Testing Your Application with JUnit [Feb 2010]
by John Stegeman
A primer on creating unit tests for Oracle Application Development Framework projects and executing them from within Oracle JDeveloper.

Oracle ADF Essentials - Building Projects with Ant [Feb 2010]
by John Stegeman
Tips for building Oracle Application Development Framework projects with Apache Ant outside of the Oracle JDeveloper environment.

Build a Java Application with Eclipse, Spring, and Oracle WebLogic Server [Feb 2010]
by Dustin Marx
Oracle Enterprise Pack for Eclipse makes developing applications for the Spring Framework and/or for Oracle WebLogic Server easier. Here's how.

Overview of Performance Tuning Tools in Oracle Fusion Middleware [Feb 2010]
by Olaf Heimburger
Oracle Fusion Middleware comes with a great toolset for investigating suspicious application behavior.

The Route to Success [01-Jan-2010]
by Steve Muench
Use task flow routers for conditional navigation.

Interoperability Between Oracle and Microsoft Technologies, Using RESTful Web Services [1-Dec-2009]
by John Charles Olamendy
A guide to developing REST Web services using the Jersey framework and Oracle JDeveloper 11g

One Smart Combo [14-Oct-2009]
by Steve Muench
Let end users choose, search for, or manually enter valid values.

Turn Applications into Portlets [19-Aug-2009]
by Vanessa Wang
Use Oracle WebCenter to integrate applications and task flows with other applications.

At the Breaking Point [19-Aug-2009]
by Steve Muench
Debug more effectively with Oracle Application Development Framework.

Ajax and Partial-Page Refresh in Oracle ADF Rich Client [13-July-2009]
by Lucas Jellema & Chris Muir
Get an overview of the support for Ajax and PPR in the Oracle ADF Faces Rich Client constituent of Oracle ADF 11g From Oracle ACE Directors Lucas Jellema and Chris Muir.

Targets, Accessors, and Trees [01-June-2009]
by Steve Muench
Hierarchical data displays are simple with Oracle Application Development Framework.

Web Services Support in Oracle Enterprise Pack for Eclipse [01-May-2009]
byRonald van Luttikhuizen
Learn about the value-add Web Services development support in Oracle Enterprise Pack for Eclipse 11 g via a step-by-step tutorial.

Extending a Helping Hand [01-May-2009]
by Steve Muench
Add custom features to improve team productivity.

High-Performance Oracle JDBC Programming [April 2009]
by Yuli Vasiliev
Learn how to improve performance of Oracle-driven JDBC programs by leveraging connection and statement pooling features.

Introduction to Oracle Enterprise Pack for Eclipse 11g JPA Workbench [March 2009]
by Andrei Cioroianu
Learn how to use Oracle Enterprise Pack for Eclipse (OEPE) to build Java EE applications that map objects to relational databases, using Java Persistence API (JPA).

A Ride at the OK (or Cancel) Corral [02-Mar-2009]
by Steve Muench
Configure nested transactions using Oracle ADF task flows.

Easier Interactive Data Entry [18-Dec-2008]
by Steve Muench
Improve the end-user experience with declarative LOVs and automatic partial page refresh.

Developing for the Apple iPhone with Oracle JDeveloper and ADF [19-Dec-2008]
by Joe Huang
Any developer can rapidly create a compelling iPhone Web app today, using Oracle JDeveloper and ADF. This tech article explains how.

Oracle ADF Development Essentials: Version Control with Subversion - Using a Repository for Single-User Projects [11-Dec-2008]
by John Stegeman
Learn how to create a repository and start using Subversion for version control in a single-user environment.

Oracle ADF Development Essentials: Version Control with Subversion - Managing Versions in a Team Environment [11-Dec-2008]
by John Stegeman
Use Subversion to help you manage versions in a team environment.

Oracle ADF Development Essentials: Version Control with Subversion - Avoiding "Gotchas" [11-Dec-2008]
by John Stegeman
How to avoid or circumvent some of the common "gotchas" that arise when using Subversion for Oracle ADF development.

Implementing Cell Highlighting in JSF-based Rich Enterprise Apps [07-Nov-2008]
by Lucas Jellema
Help your end-users digest information by implementing cell highlighting in your JavaServer Faces app.

Developing a Regional Accent [01-Nov-2008]
by Steve Muench
Use task flows as regions to improve UI reuse.

Take a REST on JAX-WS with WebLogic Server 10.3 [September 2008]
by Symon Chang
This article uses a sample location search application to demonstrate how to build a Representational State Transfer (REST) implementation using WebLogic Server 10.3.

Automating Java Performance Tuning [28-Sep-2008]
by Carl Brahms
Why automating the load generation and performance tuning process can save a lot of time and effort.

Querying JPA Entities with JPQL and Native SQL [26-Sep-2008]
by Yuli Vasiliev
Learn how to take advantage of the Java Persistence query language and native SQL when querying over Java Persistence API entities.

Using Request-Response SOAP over JMS Web Services [9-Sep-2008]
by Bob Murphy
Using SOAP over JMS transport can be more scalable and efficient than over HTTP; here are some tips to get started.

Task and You Shall Receive [01-Sep-2008]
by Steve Muench
Visually assemble applications from reusable task flows.

Oracle Workshop's Support for Java EE 5 Web Standards [13-Aug-2008]
by Andrei Cioroianu
Get an introduction to developing Java EE Web applications, using Oracle Workshop for WebLogic.

Extending Oracle WebLogic Workshop 10 with Ant [29-July-2008]
by John Liptak
Learn how to extend the built-in features of Oracle WebLogic Workshop using a combination of generated and custom Ant build files.

A Home for Your Chrome [23-June-2008]
by Steve Muench
Easily enforce consistent look and feel with page templates.

Basic Java Persistence API Best Practices [30-May-2008]
by Dustin Marx
Consider and employ these simple approaches to make your Java Persistence API applications more maintainable.

Creating Oracle Coherence Caches in Oracle JDeveloper [9-May-2008]
by Deepak Vohra
Learn how to create and configure an Oracle Coherence cache in Oracle JDeveloper, step by step.

Enlightened Development [01-May-2008]
by Steve Muench
Simplifying common navigation and coding tasks.

Build a Google Talk Client Using Oracle ADF Faces Rich Client and the Active Data Service [18-Apr-2008]
by Lucas Jellema
Oracle ACE Director Lucas Jellema explains how to build a rich Java client that fully integrates with Google Talk, step by step.

Introduction to Grails Development [18-Apr-2008]
by Harshad Oak
Learn how to build a simple Grails app using Oracle JDeveloper as your IDE, from Oracle ACE Director (Oracle Fusion Middleware) Harshad Oak.

Using Oracle Berkeley DB Java Edition as a Persistence Manager for the Google Web Toolkit [25-Feb-2008]
by Marc Audet
When building Web applications with the Google Web Toolkit, using Berkeley DB Java Edition as a persistent data store can reduce project costs significantly.

Declarative Data Filtering [11-Feb-2008]
by Steve Muench
Define multiple query expressions and build search forms with ease.

Services with a Smile [01-Jan-2008]
by Steve Muench
Create data-centric Web services for SOA development in minutes.

Integrating the Oracle Designer Legacy Table API with Oracle JDeveloper 11 g ADF Business Components [25-Oct-2007]
by Chris Muir
Learn how to give your Designer-based systems new life by integrating the Oracle Designer Table API with Oracle JDeveloper.

Testing BPEL in the Real World [18-Oct-2007]
by Lonneke Dikmans
Use the Oracle BPEL Test Framework to improve the quality of your BPEL processes.

Enhanced Calculation and Validation [18-Oct-2007]
by Steve Muench
Do even more in Oracle Application Development Framework 11 g—without code.

Better JPA, Better JAXB, and Better Annotations Processing with Java SE 6 [5-Sept-2007]
by Dustin Marx
Apply Java SE 6 incorporation of annotation processing and JAXB 2.0 to improve your JPA-based application deployment experience.

Mashing Google Maps with Oracle Database [28-Aug-2007]
by Chris Schalk
Easily build a mashup application that integrates Oracle data with the Google Maps API using Oracle XML DB.

Defining a Cascading List of Values [17-Aug-2007]
by Steve Muench
Setting up LOVs is easier than ever with Oracle JDeveloper 11 g.

Implementing Row-Level Security in Java Applications [7-July-2007]
by Lonneke Dikmans
Learn how to enforce row-level security across your JEE application, from database to cache.

Integrating Oracle Forms into Oracle ADF Faces [21-June-2007]
by Wilfred van der Deijl
Learn a technique for extending existing Oracle Forms applications using Oracle Application Development Framework (ADF) components.

Producing Parameterized Pages [21-June-2007]
by Steve Muench
Use HTTP request parameters to retrieve rows to view and edit.

Working Around Silos [21-June-2007]
by Marta Bright
The Java Content Repository provides access to content silos.

Using Oracle TopLink with the Spring Framework [updated 4-June-2007]
by Lonneke Dikmans
Build a sample application using Spring 2.0 and Oracle TopLink with Oracle JDeveloper 10 g, step by step.



Beyond Declarative Validation [1-May-2007]
by Steve Muench
Implement more-complex business logic using Java.

Spring Time [01-May-2007]
by Rich Schwerin
Oracle delivers solutions for Spring Framework-based applications.

Breaking Out of the Browser [11-May-2007]
by Steve Muench
Simplify your Java desktop applications by using Oracle ADF Swing.

Embedded Java Persistence [11-Mar-2007]
by Jonathan Gennick
Oracle Berkeley DB Java Edition provides painless persistence to Java objects.

Using EJB3 with Ajax [10-March-2007]
by Andrei Cioroianu
Learn how to build a Java EE application that uses Ajax, JavaServer Faces, and ADF Faces for the Web tier and EJB3 for the business logic.

Modeling Tables and Components [17-Jan-2007]
by Steve Muench
Maintain your data-centric business services with visual diagrams.

Learning Oracle ADF: A Beginner's Story [20-Nov-2006]
by Thomas Moore
This case study offers a brief but detailed introduction to UI development using Oracle Application Development Framework (ADF).

Taking JPA for a Test Drive [13-Nov-2006]
by Samudra Gupta
Read this real-world Oracle TopLink case study to understand nuances involved in the use and deployment of Java Persistence Architecture (JPA).

Integrating Oracle XML Publisher with Oracle JDeveloper 10 g [08-Nov-2006]
by Deepak Vohra
Learn how to use the FO Processor Engine, XSL-FO Utility, and PDF Document Merger in Oracle XML Publisher.

Jump-Start J2EE Development [26-Oct-2006]
by Steve Muench
Finish development faster with Oracle JHeadstart.

Harnessing the Active Data Model [28-Aug-2006]
by Steve Muench
Going beyond basic data access with custom service methods.

A New Face on the Block [01-Jul-2006]
by Steve Muench
Oracle ADF offers new JSF support and enhanced, visual, declarative development.

Enabling Data Exchange in Ajax Applications [20-Jun-2006]
by Andrei Cioioranu
Learn how to transfer data between Ajax clients and Java servers with XML and JavaScript Object Notation.

Validating Forms with Ajax [10-May-2006]
by Deepak Vohra
Learn how to build a Web application using Ajax in Oracle JDeveloper 10.1.3.

"Hello Ajax"! How to Do the Ajax Thing with Oracle JDeveloper [02-May-2006]
by Frank Nimphius
Get a quick-start introduction to Ajax programming from Oracle ACE Frank Nimphius by creating a simple "Hello World".

Tuning Your View Objects [01-May-2006]
by Steve Muench
What you don't know can hurt your application's performance.

A Hype-Free Introduction to AJAX [11-Apr-2006]
by Chris Shalk
Get an overview of the core fundamentals of AJAX (as well as its relationship to JavaServer Faces) from Oracle's Chris Schalk, without the usual hype. (Plus, explore new AJAX "Getting Started" resources.)

Swing vs. JavaServer Faces: Which to Choose? [10-Mar-2006]
Don't know the answer? Oracle ACEs Duncan Mills and Frank Nimphius compare and contrast these two technologies and their respective advantages for different scenarios.

Standards-based Fusion [01-Mar-2006]
by Marta Bright
Oracle Fusion standards make applications hot-pluggable.

Using Bind Variables [01-Mar-2006]
by Steve Muench
Ensure maximum query performance—now and in the future.

Converting an EJB 2.0 Entity Bean to EJB 3.0 [4-Jan-2006]
by Deepak Vohra
Learn how to convert an EJB 2.0 entity bean to an EJB 3.0 entity bean in this new tutorial, step by step.

Appreciating the Entity Object [1-Jan-2006]
by Steve Muench
Declare and configure Oracle ADF entity objects instead of hand-coding Java.

Generating a JSF DataTable [01-Jan-2006]
by Deepak Vohra
Use Oracle JDeveloper and JSF to build a data table.

Back to Top

.NET

See also .NET Developer Center

Line Up Your Applications [14-Oct-2009]
by Christian Shay
Write messaging applications with ODP.NET and Oracle Streams Advanced Queuing.

Put Your Arrays in a Bind [19-Aug-2009]
by Mark Williams
Use array binding to reduce network round-trips and increase performance.

The Full Set [01-June-2009]
by Christian Shay
Use Microsoft Visual Studio for the complete .NET and Oracle Database development lifecycle.

The Right Transaction [01-May-2009]
by Mark A. Williams
Choose the ODP.NET transaction type that fits your business rules.

Instant ODP.NET Deployment [01-Nov-2008]
by Mark A. Williams
Deploy ODP.NET applications instantly with Oracle Data Access Components.

Customize the Experience [01-Sep-2008]
by Mark A. Williams
Use the built-in capabilities of ODP.NET to provide globalization and personalization.

Build a .NET Application on the Oracle Database with Visual Studio 2005 or 2008 [30-Sept-2008]
by John Paul Cook
Learn the basic yet essential processes involved in building a .NET application that uses an Oracle database (with Visual Studio 2005/2008).

Cache Payback [23-June-2008]
by Mark A. Williams
Put performance in your pocket with the client result cache.

It Takes All Types [01-May-2008]
by Christian Shay
Build applications with Oracle Developer Tools for Visual Studio and Oracle user-defined types.

Using PL/SQL Associative Arrays [17-Jan-2007]
by Mark A. Williams
Bring the power of PL/SQL stored procedures to ODP.NET.

Debugging PL/SQL from .NET [28-Aug-2006]
by Mark A. Williams
Debug PL/SQL in Microsoft Visual Studio with Oracle Developer Tools.

Improve ODP.NET Performance [01-Jul-2006]
by Mark A. Williams
Take advantage of connection pooling, fetch size controls, and statement caching.

Following the Changes, Part Two [01-May-2006]
by Mark A. Williams
Use database change notification with ODP.NET and Oracle Database 10 g Release 2.

Following the Changes, Part One [01-Mar-2006]
by Mark A. Williams
Use database change notification with ODP.NET and Oracle Database 10 g Release 2.

Cursor In, Cursor Out [01-Jan-2006]
by Mark A. Williams
The easy way to send a ref cursor to PL/SQL with ODP.NET and Oracle Database 10 g Release 2

Back to Top

PHP, Python, Ruby, and Open Source

See also PHP Developer Center, Scripting Languages Developer Center

HR Schema on Rails (updated for Rails 2.3.4) [13-Nov-2009]
by Casimir Saternos
This popular how-to for creating a Ruby on Rails-based Web front end to Oracle's HR demo schema has been updated for Rails 2.3.4.

Building Oracle Database-backed Web Applications in Django [20-Aug-2009]
by Yuli Vasiliev
Learn how to configure Django to interact with an Oracle database and then use ORM for database connectivity.

High Performance and Availability with Oracle RAC and PHP [16-June-2009]
by John Lim
Review real-world experiences in deploying a business-critical PHP app over Oracle Real Application Clusters.

Python cx_Oracle 5.0 New Features Overview [April 2009]
by Anthony Tuininga
An overview of new features in cx_Oracle, the standard Python extension for accessing the Oracle Database, from its developer.

High Concurrency with Python and Oracle Database [April 2009]
by Yuli Vasiliev
Learn how to improve the throughput and responsiveness of Oracle Database-backed Python applications with the help of threading and concurrency.

Introduction to Oracle Enterprise Pack for Eclipse 11g JPA Workbench [March 2009]
by Andrei Cioroianu
Learn how to use Oracle Enterprise Pack for Eclipse (OEPE) to build Java EE applications that map objects to relational databases, using Java Persistence API (JPA).

Python Data Persistence with Oracle Database [February 2009]
by Yuli Vasiliev
Learn how to build your own Python app backed by Oracle Database, utilizing Oracle XML DB, Python scripts, and PL/SQL stored procedures.

Installing PHP 5.2 for Oracle on Mac OS X 10.5 (Leopard) [22-Jan-2009]
by Tony Bibbs
How to get your Mac set-up to build Oracle-based PHP applications.

Oracle Symfony in PHP Minor [10-July-2008]
by Mladen Gogala
Oracle Database 11 g and the Symfony Web PHP Framework can make beautiful music together, as illustrated by this simple sample app.

Using Python with TurboGears and Oracle [26-Nov-2007]
by Daniel Rubio
Learn how TurboGears offers Python-istas an excellent framework for creating Web-enabled applications backed by an Oracle database.

Easy Integration: From XML to the Datastore Without the Mess [18-June-2007]
by Matt Kern
Enforce simple persistence of XML data to Oracle using ActiveRecord and XML::Mapping.

Tagging with Oracle and Ruby on Rails [18-June-2007]
by Matt Kern
Clear the confusion and add tags and tag clouds to your Oracle+Rails application.

Guide to Ruby on Rails Migrations [18-June-2007]
by Matt Kern
Join the exodus and make managing your database schemas a snap.

Tagging with Oracle and Ruby on Rails [18-June-2007]
by Obie Fernandez
Learn how to connect to Oracle from a Rails application and related authentication and performance issues.

Tips for Optimizing Rails on Oracle [15-May-2007]
by Luca Mearelli
Get tips and techniques for building more efficient Ruby on Rails applications on Oracle Database, from tweaking connection parameters to using execution plans and indexes.

Spring Time [01-May-2007]
by Rich Schwerin
Oracle delivers solutions for Spring Framework-based applications.

Delivering Productivity with Choice [01-March-2007]
by Rich Schwerin
Oracle is not just a member of the Eclipse Foundation, but a leader in Eclipse development.

Daniel F. Savarese [01-March-2007]
by Rich Schwerin
Ruby on Rails speeds development with Oracle Database.

Embedding Open Source [17-Jan-2007]
by Rich Schwerin
The Oracle Berkeley DB family of products exemplifies Oracle's open source commitment.

The "Ruby on Rails with Oracle" FAQ [5-Dec-2006]
by Casimir Saternos
Exploring Ruby on Rails (RoR)? This new FAQ provides basic information about connecting to Oracle, installation, and creating Oracle Database XE + RoR applications.

Using Oracle TopLink with the Spring Framework [25-Sept-2006]
by Lonneke Dikmans
Oracle Fusion Middleware Regional Director Lonneke Dikmans explains how to build a sample application using Spring 1.2.8 and Oracle TopLink with Oracle JDeveloper 10 g, step by step.

Build a Google Earth Interface on Oracle Database XE [23-Aug-2006]
by Rich Gibson
Get an overview of spatial data, explore ways to add spatial attributes to existing data, and learn how to use Google Earth to "fly" over aerial imagery including that data.

Build a Rapid Web Development Environment for Python Server Pages and Oracle [24-Jul-2006]
by Przemyslaw Piotrowski
Get into high-level Web programming with the reliable Oracle Database 10 g Express Edition, scalable Apache Web server, and intuitive, object-oriented Python programming language.

HR Schema on Rails [28-Jun-2006]
by Casimir Saternos
Learn techniques for creating a Ruby on Rails Web application that utilizes a legacy schema.

Grails on Oracle for Java Developers [17-May-2006]
by Tug Grall
Learn how to quickly build a Grails application on Oracle Database XE, and then deploy it to Oracle Application Server 10 g.

PHP for the Enterprise [01-May-2006]
by Rich Schwerin
Dynamic scripting for agile application development.

Ruby on Rails on Oracle: A Simple Tutorial [11-Apr-2006]
by Richard Monson-Haefel
Rails is an easy framework to work with, but like any technology it takes time to master.

Installing Oracle Database 10 g Express Edition and Zend Core for Oracle [31-Mar-2006]
by Christopher Jones & Alison Holloway
A step-by-step guide to installing Oracle Database 10 g Express Edition and Zend Core for Oracle, as well as using the PHP OCI8 extension.

Wrapping Your Brain Around Oracle + Python [24-Mar-2006]
by Catherine Devlin
Build a sample application using Python—the open-source, object-oriented language infamous for its ease of use—and learn those aspects of Python most important for Oracle users.

Using the GRASS Mapping Tool with Oracle [10-Mar-2006]
by Stephan Holl, Helena Mitasova, and Markus Neteler
Connecting to an external database allows you to build sophisticated geospatial apps with the open-source GRASS GIS tool. Learn how with Oracle!

Back to Top

SQL & PL/SQL

Getting Recursive - Querying Hierarchical Data in Oracle Database 11 g Release 2 [Feb 2010]
by Tim Hartley
A quick primer on querying hierarchical data in Oracle Database 11 g Release 2.

On Privacy and Function [01-Jan-2010]
by Steven Feuerstein
Use Oracle Virtual Private Database and Function Result Cache—securely.

Building Applications in the Cloud [19-Aug-2009]
by David Peake
Combine Oracle Application Express and Amazon EC2.

On Looping, First, and Last [19-Aug-2009]
by Steven Feuerstein
Choose the best approach to prevent a VALUE_ERROR exception.

Introduction to Oracle SQL Developer Data Modeler [28-July-2009]
by Casimir Saternos
Learn how to install/configure Oracle SQL Developer Data Modeler and then perform some common tasks.

Developing Secure Applications [01-June-2009]
by David Peake
Defend your Oracle Application Express applications against unauthorized use.

First Things First [01-June-2009]
by Steven Feuerstein
Ask the right questions before starting construction of your new PL/SQL-based application.

Converting Forms [01-May-2009]
by David Peake
Modernize Oracle Forms applications with Oracle Application Express.

The Magic Kingdom [01-May-2009]
by Steven Feuerstein
Choose the best way to manage literal values.

More New PL/SQL Features [01-May-2009]
by Sushma Jagannath
Improve performance in Oracle Database 11 g with new PL/SQL features.

Creating Custom Authentication [01-May-2009]
by Raj Mattamal
Build single sign-on/sign-off for a suite of applications in Oracle Application Express.

On Avoiding Termination [02-Mar-2009]
by Steven Feuerstein
Continue PL/SQL execution beyond exceptions.

Improving PL/SQL [02-Mar-2009]
by Sushma Jagannath
Improve performance in Oracle Database 11 g with new PL/SQL features.

Improving Application Performance [02-Mar-2009]
by Sue Harper
Manage and tune Oracle Application Express applications with Oracle SQL Developer.

Easy Application Attachments [18-Dec-2008]
by David Peake
Incorporate BLOB support in Oracle Application Express.

On Emulating FINALLY [18-Dec-2008]
by Steven Feuerstein
Code PL/SQL to function like the Java FINALLY section.

On Cursor FOR Loops [01-Nov-2008]
by Steven Feuerstein
It's important to know when not to use cursor FOR loops.

Programming Productively [01-Nov-2008]
by Sue Harper
Use Oracle SQL Developer to work efficiently with PL/SQL constructs.

On Signatures and Changing WHERE [01-Sep-2008]
by Steven Feuerstein
Best practices for changing headers and handling different WHERE clauses.

On Exceptions and Rules [23-June-2008]
by Steven Feuerstein
Best practices for where, when, and how to handle exceptions.

On the PGA and Indexing Collections [01-May-2008]
by Steven Feuerstein
Best practices for knowing your PGA impact and indexing collections.

The Power of Two [01-May-2008]
by David Peake
Use Oracle SQL Developer to aid Oracle Application Express development.

On BULK COLLECT [11-Feb-2008]
by Steven Feuerstein
Best practices for knowing your LIMIT and kicking %NOTFOUND.

Building Interactive Reports [11-Feb-2008]
by David Peake
Users can customize interactive reports with Oracle Application Express.

Reporting from Your Browser [01-Jan-2008]
by David Peake
Publish high-fidelity business intelligence reports with Oracle Application Express.

On Continuing and Executing [18-Oct-2007]
by Steven Feuerstein
Best practices for PL/SQL in Oracle Database 11g and multilevel, string-indexed collections.

Application Integration Workshop [18-Oct-2007]
by David Peake
Consuming Web services with Oracle Application Express.

Working with PL/SQL [18-Oct-2007]
by Sue Harper
Edit, compile, run, and debug PL/SQL code easily with Oracle SQL Developer.

On the PL/SQL Function Result Cache [17-Aug-2007]
by Steven Feuerstein
Best practices—and preparation—for PL/SQL in Oracle Database 11 g.

Express Web 2.0 [17-Aug-2007]
by David Peake
Create dynamic interfaces that minimize page refresh with Oracle Application Express.

On Invokers and Outs [21-June-2007]
by Steven Feuerstein
Best practices for invoker rights and functions.

On the Old, the New, and ORA-22160 [11-May-2007]
by Steven Feuerstein
Best practices for managing old and new information and preventing FORALL errors.

Application Migration Workshop [11-May-2007]
by David Peake
Migrate from Microsoft Access to Oracle Application Express.

Sizing Up Performance [17-Jan-2007]
by Mike Hichwa
Tips and techniques for optimal Oracle Application Express performance

Using PL/SQL Associative Arrays [17-Jan-2007]
by Mark A. Williams
Bring the power of PL/SQL stored procedures to ODP.NET.

The Right Place for PL/SQL [17-Jan-2007]
by Steven Feuerstein
Best practices for PL/SQL location, location, location

Taking Up Collections [26-Oct-2006]
by Mike Hichwa
Use collections to manage session state in Oracle Application Express.

On Object Types in Collections [26-Oct-2006]
by Steven Feuerstein
Best practices for retrieving objects and object attributes from objects

Taking Up Collections [26-Oct-2006]
by Mike Hichwa
Use collections to manage session state in Oracle Application Express.

On Generics and Traces [28-Aug-2006]
by Steven Feuerstein
Best practices for string procedures and tracing.

Express Lockdown [28-Aug-2006]
by Raj Mattamal
Lock down your Oracle Application Express applications.

Making the Most of Oracle SQL Developer Reports [11-Jul-2006]
by Lewis Cunningham
Get tips for utilizing the reporting capabilities in Oracle's free database development tool, from Oracle ACE Lewis Cunningham.

On Conditional Compilation [01-Jul-2006]
by Steven Feuerstein
Apply best practices to PL/SQL conditional compilation.

Single-Step Deployment [01-Jul-2006]
by Raj Mattamal
Oracle Application Express deploys an application with a single file.

Building an Ajax Memory Tree in Oracle Application Express [22-May-2006]
by Scott Spendolini
Learn how to create an Ajax-based memory tree in Oracle Application Express, step by step.

On Confusion and Recompilation [01-May-2006]
by Steven Feuerstein
Apply best practices to program naming, recompiling invalid programs, and collecting.

Build a Menu Framework [01-May-2006]
by Tony Jedlinski
Centralize applications with a table-driven menu framework.

Building Express Forms [01-May-2006]
by Raj Mattamal
Tune up your Oracle Application Express forms with JavaScript.

Oracle SQL Developer Soars [01-May-2006]
by Jonathan Gennick
Bring the power of a GUI-based workbench to SQL and PL/SQL.

On Variables, Moving, and Meaning [01-Mar-2006]
by Steven Feuerstein
Apply best practices to cursor variables, bidirectional cursor access, and error messages.

Following the Changes, Part One [01-Mar-2006]
by Mark A. Williams
Use database change notification with ODP.NET and Oracle Database 10 g Release 2.

Surveying Your Application Needs [01-Mar-2006]
by Raj Mattamal
Oracle Application Express builds a quick survey application.

Answering PL/SQL [01-Jan-2006]
by Steven Feuerstein
Apply best practices to defining arrays and stripping strings.

Back to Top

Testing & Performance


Put Your Arrays in a Bind [19-Aug-2009]
by Mark Williams
Use array binding to reduce network round-trips and increase performance.

Monitoring Performance Using The WebLogic Diagnostics Framework [17-Aug-2009]
by Mike Tico
A quick tour of your options for gathering server and application performance data from Oracle WebLogic Server.

Developing Secure Applications [01-June-2009]
by David Peake
Defend your Oracle Application Express applications against unauthorized use.

How to Develop, Maintain, and Support a Quality Management and Development Process [01-Oct-2008]
by James Downs
Get an overview of real-world testing methodologies, as well as a getting-started introduction to Oracle Test Manager for Web Applications.

Automating Java Performance Tuning [28-Sep-2008]
by Carl Brahms
Why automating the load generation and performance tuning process can save a lot of time and effort.

Customize the Experience [01-Sep-2008]
by Mark A. Williams
Use the built-in capabilities of ODP.NET to provide globalization and personalization.

Cache Payback [23-June-2008]
by Mark A. Williams
Put performance in your pocket with the client result cache.

Managing File Versions [23-June-2008]
by Sue Harper
Edit files and use version control in Oracle SQL Developer 1.5.

Performing Through Changes [11-Feb-2008]
by Arup Nanda
Measure the impact of changes on SQL workload with SQL performance analyzer.

Better Workload, Better Testing [01-Jan-2008]
by Arup Nanda
Use database replay to record and replay database activities for better testing.

Testing BPEL in the Real World [18-Oct-2007]
by Lonneke Dikmans
Use the Oracle BPEL Test Framework to improve the quality of your BPEL processes.

Sizing Up Performance [17-Jan-2007]
by Mike Hichwa
Tips and techniques for optimal Oracle Application Express performance

Back to Top