Technical Articles for Developers and Architects
View Complete Article Index
Business Intelligence
See also BI & Data Warehousing Technology Center
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.
Building Analytic Workspaces [01-Nov-2005]
by Brian Carr
Use Oracle AWM 10g to build analytic workspaces.
Technical Note: Melding Oracle Text and Oracle Business Intelligence Discoverer [21-Oct-2005]
by Brian Carr
How to harness the power of Oracle Text and then deliver the results from Discoverer—providing your users with a one-stop shop for all their ad-hoc reporting needs.
Building BI Dashboards with Oracle Database 10g, Oracle Discoverer, and Oracle Portal [25-Feb-2005]
by Mark Rittman
Learn how to create your own business intelligence dashboard with software you can download today from OTN.
Building Open-Standard Portlets for Location Information [11-Feb-2005]
by Justin Lokitz
Learn how to integrate geographic maps into open-standard portlets.
Web Analytics Using Oracle Application Server Discoverer [01-Oct-2004]
by Timothy Cambier & Brian Carr
Learn how to create your own website reporting system using the reporting capabilities of Discoverer and log files generated from Apache web server.
Use Location Information in Enterprise Reporting [26-May-2004]
by Justin Lokitz & Madeline Alameda
Learn how to create dynamic maps that make the relationships between attribute and location-based information a lot more visible for business intelligence analysis.
Back to Top
Java & Frameworks
See also: Java Developer Center
Enlightened Development [01-May-2008]
by Steve Muench
Simplifying common navigation and coding tasks.
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 11g 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 11g—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 11g.
Implementing Row-Level Security in Java Applications [7-July-2007]
by Lonneke Dikmans, Oracle Fusion Middleware Regional Director
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 10g, 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 10g [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.
Building a Tiles Application with JSF Components in JDeveloper [9-Dec-2005]
by Deepak Vohra
Learn how to develop a Tiles application in Oracle JDeveloper 10g comprising several JSF component pages.
Add Some Spring to Your Oracle JDBC Access [18-Nov-2005]
by Dustin Marx
Learn how to use the Spring Framework to improve your Oracle JDBC access.
Virtualize Your Database with Web Services [2-Nov-2005]
by Kuassi Mensah
Explore the Database Web Services capabilities of Oracle Database 10g, as well as their role in service-oriented architecture (SOA).
Working with Master/Detail Data [1-Nov-2005]
by Steve Muench
Navigating, joining, and presenting related data in an easier way.
Reusability in Web Applications [15-October-2005]
by Andrei Cioroianu
Learn how to reuse Web content and Java code with the help of JSP Tag Files, JSF, and Oracle ADF Faces.
Building Faster Java [26-August-2005]
by Harshad Oak
Optimize your Java applications with Oracle JDeveloper 10g tools.
Creating Search Pages [26-August-2005]
by Steve Muench
Help users find what they're looking for.
Building XML-Enabled JavaServer Faces Applications [12-August-2005]
by Yuli Vasiliev
Learn how to build a JavaServer Faces (JSF) application that interacts with Oracle XML DB, the Oracle Database feature that enables high-performance native storage and retrieval of XML content.
Making the Most of Java's Metadata, Part 2: Custom Annotations [1-Aug-2005]
by Jason Hunter
Learn how to write your own annotation types and make use of built-in annotations to control their behavior.
Managing State in Service-Oriented Architecture [22-July-2005]
by Mark M. Davydov
An introduction to using explicit state identifiers to support conversational Web services in an SOA.
Technical Note: Using FOP in Oracle JDeveloper [22-June-2005]
by Deepak Vohra
Browsing and Editing Data [17-June-2005]
by Steve Muench
Drag and drop your way to the Web.
Testing 1, 2, 3 . . . [17-June-2005]
by Phil Zoio
Best practices for testing J2EE database applications
Simplifying Development [17-June-2005]
by Rich Schwerin
Use EJB 3.0 to streamline your application development and standardize persistence for Java.
A Hands-on Introduction to BPEL, Part 2: Advanced BPEL [06-May-2005]
by Matjaz B. Juric
Learn how to use BPEL to model complex business processes via these hands-on examples.
Fact-Finding with MapViewer [01-May-2005]
by Liujian Qian and Jayant Sharma
Map answers with Oracle Application Server 10g.
Working with Data [01-May-2005]
by Steve Muench
Using Oracle ADF to query, update, and publish data
Picturing Program Design [01-May-2005]
by Kelli Wiseth
UML offers standard notation for modeling complex systems.
Using Oracle ADF Faces in Existing JSF Applications [07-Apr-2005]
by Andrei Cioroianu
Learn how to integrate Oracle ADF Faces into existing JSF projects and take advantage of the rich UI components provided by that framework
Out-of-Container EJB 3.0 Testing with Oracle Entity Test Harness [04-Mar-2005]
by Debu Panda
Learn how Oracle's Entity Test Harness makes it easier to practice Test-Driven Development with EJB 3.0 entity beans.
Oracle Forms in the SOA World [01-Mar-2005]
by Robin Zimmermann
Oracle Forms can be part of your service-oriented architecture.
Guarantee SOAP Message Integrity [01-Mar-2005]
by Mike Lehmann
Use digital signatures to check sender identity and ensure that messages remain unaltered.
Starting with Oracle ADF [01-Mar-2005]
by Steve Muench
Understanding the basics of application organization.
Aggregate Data with XQuery [01-Mar-2005]
by Nilesh Junnarkar, Nirav Chanchani, and Julie Basu
Oracle XML Data Synthesis brings information together.
A Hands-On Introduction to BPEL [17-Feb-2005]
by Matjaz Juric
Learn how to create an example business process that combines a set of fictional travel-related web services and then deploy it to the Oracle BPEL Process Manager runtime environment.
Making the Most of Java's Metadata [21-Jan-2005]
by Jason Hunter
Learn how to use the metadata annotations provided in J2SE 5.0.
Building Database-driven Applications with JavaServer Faces [07-Jan-2005]
by Andrei Cioroianu
Develop JSF-based Web applications that update and query a relational database using Oracle TopLink and JSTL's SQL tags.
Securing Web Services [01-Jan-2005]
by Mike Lehmann
Move transport-based security to message-based security.
Forms Functionality in J2EE [01-Jan-2005]
by Steve Muench
Leverage your Oracle Forms skills in J2EE frameworks.
Design First, Code Next [29-Nov-2004]
Week 3 of the Mastering J2EE Application Development Series
by Scott Ambler
Model J2EE applications with style using a collection of techniques for creating effective Unified Modeling Language (UML) diagrams.
Master and Commander [19-Nov-2004]
Week 2 of the Mastering J2EE Application Development Series
by Julien Dubois
As a project manager, choosing among project management tools and practices are the most important decisions you will make.
Slicing and Dicing J2EE [12-Nov-2004]
Week 1 of the Mastering J2EE Application Development Series
by Ted Neward
Understanding your application's needs up front goes a long way toward alleviating J2EE's complexity.
From ADF UIX to JSF [01-Nov-2004]
by Jonas Jacobi
Oracle ADF Faces Components brings a library of reuse to JavaServer Faces.
Web Services Management Arrives [01-Nov-2004]
by Mike Lehmann
Using the new infrastructure within Oracle Application Server.
Integration Imperative [01-Nov-2004]
by Rich Schwerin
Business Process Execution Language (BPEL) speaks services.
Developing a Project with Oracle JDeveloper 10g and the Maven Plugin [29-Oct-2004]
by Deepak Vohra
Learn how to develop a JDeveloper (Java application) project with the Maven JDeveloper Plugin.
Developing JSTL-like Tags with JSP 2.0 [29-Oct-2004]
by Andrei Cioroianu
Learn how to use the Simple Tags API and build custom tags that evaluate JSP expressions, control the flow in a JSP page, and create Java Collections.
Managing Software Entropy with RefactorIT and Oracle JDeveloper 10g [14-Oct-2004]
by Dr. Robert J. Pefferly, Jr., Yuri Schimke, and Tanel Unt
Learn how to manipulate obtuse code into elegant source code that is both efficient and manageable using RefactorIT and Oracle JDeveloper 10g .
Technical Note: Developing UML Diagrams from XMI in Oracle JDeveloper 10g [08-Oct-2004]
by Deepak Vohra
An Introduction to Java Map Collection Classes [14-Sept-2004]
by Jack Shirazi
Learn the basics of one the most commonly used collection types, Maps, and how to optimize Maps for your application-specific data.
Giving Legs to Web Services [01-Sep-2004]
by Caroline Kvitka
WS-I supports Web services working together.
Your First BPEL Project [01-Sep-2004]
by Mike Lehmann
Learn how to wire a Web service to BPEL.
Rapid Struts Development [01-Sep-2004]
by Harshad Oak
Use Oracle JDeveloper 10g to build Struts applications.
Extend Your J2EE Application Server for Instant Messaging [01-Sept-2004]
by Prabhu Kapaleeswaran
Link an instant messaging subsystem to your J2EE middleware using J2EE Connector Architecture (JCA)
In-Container Testing with JUnit and Oracle JDeveloper [24-Aug-2004]
by Julien Dubois
Dubois argues that in-container testing with the JUnit framework is superior to a mock objects approach for integration testing, and explains how to apply those techniques using Oracle JDeveloper.
Using the JSP 2.0 EL API [21-July-2004]
by Andrei Cioroianu
Learn how to evaluate JSP expressions dynamically, use the Expression Language (EL) in XML configuration files, and optimize EL usage when presenting SQL result sets.
Ant 1.6 for Task Writers [21-July-2004]
by Stefan Bodewig
Take advantage of the changes in Ant 1.6 internals to write a task or even a library of tasks.
New Ant 1.6 Features for Big Projects [24-June-2004]
by Stefan Bodewig
Learn new features of Ant 1.6 and see how they might impact the way you structure your build process.
Keep Your Connections [23-June-2004]
by Kuassi Mensah
Use Implicit Connection Cache for transparent cache access.
Developing Faces [23-June-2004]
by Chris Schalk
Use Oracle JDeveloper 10g to develop JavaServer Faces applications.
Weaving Web Services Together [23-June-2004]
by Mike Lehmann
Business Process Execution Language streamlines connecting and coordinating Web services.
Exposing EJB Components as Business Services: An Architect's View [17-June-2004]
by Mark Davydov
Design patterns have an underappreciated yet far-reaching impact on service-oriented architecture (SOA), so choose your pattern wisely.
Creating JSP 2.0 Tag Files [13-May-2004]
by Andrei Cioroianu
Learn how to build reusable Web templates and database scripts using JSP, JSTL, and SQL.
Reuse Tiles and Simplify UI [1-May-2004]
by James Holmes
Simplify and enhance Struts JSP development with Tiles.
Monitor, Control, and Extend with JMX [1-May-2004]
by Cameron O'Rourke
Improve your applications with Java Management Extensions.
Managing Web Services [1-Ma1-2004]
by Mike Lehmann
Take advantage of SOAP on the wire.
Network Communication Support in J2SE 1.4 [26-Mar-2004]
Jason Hunter demonstrates how Java 2 Platform, Standard Edition 1.4 provides support for nonblocking I/O.
Technical Note: Measuring Performance of Java Applications Using Oracle DMS [19-Mar-2004]
How to prepare your J2EE application for monitoring and then read the results.
Build a PL/SQL Web Service [12-Mar-2004]
by Jason Price
Oracle Database 10g Web Services allow you to take advantage of your development investment in PL/SQL and SQL while consuming external web services from within the database. This Technical Article takes you through all the steps of building and deploying your own.
Facing Forward with JSF [26-Feb-2004]
by Budi Kurniawan
A demonstration of JavaServer Faces (JSF) capabilities via the exercise of building an online pizza ordering system.
Extending Oracle E-Business Suite with JDeveloper [23-Jan-2004]
by Regis Louis
Modifying Oracle E-Business Suite for your organization's needs? Oracle JDeveloper offers the benefits of easy integration and flexibility.
Check Your Form with Validator [02-Jan-2004]
by James Holmes
Simplify Struts development with Validator's rich set of built-in validations.
Simplifying Database Access [02-Jan-2004]
by Kuassi Mensah
The improved Oracle JPublisher maps database entities to Java and Web services.
Back to Top
Middleware & SOA
See also SOA Technology Center
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.
Simplifying Web Services Development with the Decorator Pattern [10-Dec-2007]
by Jason Jones
Learn how to layer functionality onto your Web services without having to go through the costly code/test/deploy cycle. From Oracle ACE Director Jason Jones.
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.
An Introduction to Real-Time Data Integration [25-May-2007]
by Mark Rittman, Oracle ACE
Get an introduction to using Oracle Data Integrator, Java-based middleware that uses the database to perform set-based data integration tasks in an SOA.
Building Event-Driven Architecture with an Enterprise Service Bus [25-Feb-2007]
by Lucas Jellema, Oracle ACE and Oracle Fusion Middleware Regional Director
Learn how to configure an ESB to "publish" enterprise events using a simple example.
Mastering SOA: Orchestrating into End-to-End Processes [20-Feb-2007]
by Joan Lawson
Build agile and standard business processes that orchestrate services into end-to-end business flows.
Mastering SOA: Wiring Through an Enterprise Service Bus [13-Oct-2006]
by Brian Wilkinson and Demed L'Her
An Enterprise Service Bus (ESB) is an integral part of any enterprise-scale SOA, for a host of reasons.
Mastering SOA: Building a Portfolio of Services [6-Sept-2006]
by Dan Hynes and Salil Pradhan
In this first installment of the Mastering SOA Series, learn techniques and trade-offs involved in building out a portfolio of modular services.
Standardizing Service Endpoints [16-Feb-2006]
by Thomas Erl
Learn how to design service interface definitions that will help you reap the benefits of standardized SOA.
Virtualize Your Database with Web Services [2-Nov-2005]
by Kuassi Mensah
Explore the Database Web Services capabilities of Oracle Database 10g, as well as their role in service-oriented architecture (SOA).
Adding BPEL to the Enterprise Integration Mix [28-Oct-2005]
Part 5 of The BPEL Cookbook
by Praveen Chandran and Arun Poduval
Leverage the orchestration capability of Oracle BPEL Process Manager to enable standards-based business process integration that complements traditional EAI middleware.
Using WSIF for Integration [22-Oct-2005]
Part 4 of The BPEL Cookbook
by Matjaz B. Juric
Learn how BPEL processes can access Java classes and EJBs using WSIF.
Making BPEL Processes Dynamic [16-Sept-2005]
Part 3 of The BPEL Cookbook
by Sean Carey
Learn how to achieve dynamic binding by manipulating endpoint references at run time.
Building a Web Services Network with BPEL [16-Sept-2005]
Part 2 of The BPEL Cookbook
by Yves Coene and The Hoa Nguyen
A case study of how the European Space Agency used BPEL scopes, BPEL domains, and the Oracle BPEL Process Manager API to build a partner-friendly Web services network.
A Services-Oriented Approach to Business Rules [16-Sept-2005]
Part 1 of The BPEL Cookbook
by Kevin Geminiuc
Learn how to reduce maintenance costs and improve organizational flexibility through a services-oriented approach to business rules development and management.
Web Services—Anyhow, Anywhere [26-August-2005]
by Marta Bright
WSIF lets you access Web services independent of protocol or location.
Creating Search Pages [26-August-2005]
by Steve Muench
Help users find what they're looking for.
Managing State in Service-Oriented Architecture [22-July-2005]
by Mark M. Davydov
An introduction to using explicit state identifiers to support conversational Web services in an SOA.
Technical Note: Connection Caching in OC4J 10g 10.1.3 Data Sources [22-July-2005]
Learn how the strategic use of caching technology can improve the performance of your multitier applications, as well as how to keep multiple caches in synch across clustered environments.
Using Caches in Multi-Tier Applications: Best Practices [18-May-2005]
by Frances Zhao
Securing Web Services [01-Jan-2005]
by Mike Lehmann
Move transport-based security to message-based security.
Technical Note: Using PHP to Create Custom SSO Login and Sign-Off Pages [22-Oct-2004]
It's quick and easy to create and manage custom login and sign-off pages for Oracle Application Server Single Sign-On using PHP.
Extend Your J2EE Application Server for Instant Messaging [01-Sept-2004]
by Prabhu Kapaleeswaran
Link an instant messaging subsystem to your J2EE middleware using J2EE Connector Architecture (JCA)
Taking Abstraction One Step Further [01-Sept-2004]
by James Holmes
Reduce coding time and duplication with aspect-oriented programming.
A Look at Rich Internet Applications [23-June-2004]
by Cameron O'Rourke
Looking at technologies for going beyond the aging HTML standard.
Weaving Web Services Together [23-June-2004]
by Mike Lehmann
Business Process Execution Language streamlines connecting and coordinating Web services.
Exposing EJB Components as Business Services: An Architect's View [17-June-2004]
by Mark Davydov
Design patterns have an underappreciated yet far-reaching impact on service-oriented architecture (SOA), so choose your pattern wisely.
Reuse Tiles and Simplify UI [1-May-2004]
by James Holmes
Simplify and enhance Struts JSP development with Tiles.
Technical Note: Deploying Macromedia ColdFusion MX 6.1 Under Oracle Application Server 10g [12-Feb-2004]
by Jason Bennett
Back to Top
.NET
See also .NET Developer Center
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 10g Release 2.
Following the Changes, Part One [01-Mar-2006]
by Mark A. Williams
Use database change notification with ODP.NET and Oracle Database 10g 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 10g Release 2
Serving Winning LOBs [01-Nov-2005]
by Mark A. Williams
New features in ODP.NET make it easier than ever to handle LOBs.
Tools for Your .NET Space [01-Nov-2005]
by Christian Shay
Use ODT for fast, easy development for Oracle Database on Windows.
Using .NET Stored Procedures in Oracle [2-Nov-2005]
Part 3 of the Mastering .NET Application Development with Oracle series
by Mark A. Williams
A step-by-step guide to developing, deploying, and debugging your .NET Stored Procedures, a feature in Oracle Database 10g Release 2.
Securing a .NET Application on the Oracle Database [30-Sep-2005]
Part 2 of the Mastering .NET Application Development with Oracle series
by John Paul Cook
Learn how to take full advantage of Oracle's built-in security features in your .NET application.
Optimizing Result Set Retrieval Using ODP.NET and Ref Cursors[16-Sep-2005]
Part 1 of the Mastering .NET Application Development with Oracle series
by Mark A. Williams
Learn how to use the power of ref cursors and ODP.NET to create powerful, flexible, and scalable applications.
The Values that Bind [26-Aug-2005]
by Mark A. Williams
Improve performance in .NET applications with bind variables and ODP.NET.
Using XML with XML DB and ODP.NET [30-Nov-2004]
by Mark A. Williams
Learn how to use XML with an Oracle database, Oracle XML DB, and the Oracle Data Provider for .NET.
Using Large Objects in .NET [19-Nov-2004]
by Jason Price
Learn how to read and write to large objects (LOBs) using .NET, as well as how to read data via a BFILE.
Using Oracle Database Transactions in .NET [22-Oct-2004]
by Jason Price
Learn the basics about coding Oracle database transactions in Visual Basic .NET and C#.
Build a .NET Application on the Oracle Database [08-Sept-2004]
by John Paul Cook
Learn the basic yet essential processes involved in building a .NET application that uses an Oracle database.
Back to Top
PHP & Open Source
See also PHP Developer Center, Scripting Languages Developer Center
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 10g, 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 10g 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 10g.
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 10g Express Edition and Zend Core for Oracle [31-Mar-2006]
by Christopher Jones & Alison Holloway
A step-by-step guide to installing Oracle Database 10g 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!
Building Database-Driven PHP Applications on Oracle XML DB [15-Dec-2005]
by Yuli Vasiliev
Learn how to exploit Oracle XML DB capabilities when developing XML applications with PHP.
Add Some Spring to Your Oracle JDBC Access [18-Nov-2005]
by Dustin Marx
Learn how to use the Spring Framework to improve your Oracle JDBC access.
DeployPHP, Part 5: Zend Core for Oracle Quick Start [31-Aug-2005]
by Matt Kern
Install, deploy, and configure PHP and Oracle using the simplest method available: Zend Core for Oracle.
The Oracle+PHP Cookbook [23-October-2005]
by Various Authors
Explore new HowTo's for leveraging Oracle's PL/SQL APIs in PHP applications, provided by the PHP coders who know those APIs best.
DeployPHP, Part 4: Using the PEAR:MDB2 Database Abstraction Layer with Oracle [31-Aug-2005]
by Tobias Schlitt
Get an introduction to the use of the MDB2 database abstraction layer with PHP and Oracle, with simple as well as advanced examples.
DeployPHP, Part 3: Accelerating PHP Code Performance for Oracle [26-July-2005]
by Ilia Alshanetsky
A detailed guide to easy, effective techniques for accelerating your PHP applications, from using opcode caches, to Web server tuning, to benchmarking and profiling.
DeployPHP, Part 2: Bringing Data Security to PHP Applications [18-July-2005]
by Mikhail Seliverstov
Learn how to build and deploy lightweight PHP front-end applications without compromising the security of your data.
DeployPHP, Part 1: Top 7 Tips for Optimizing PHP and Oracle [1-July-2005]
by John Lim
In this first installment of the DeployPHP Series, get a checklist for developing and deploying powerful, scalable PHP applications on Oracle.
Using PHP 5 with Oracle XML DB [17-June-2005]
by Yuli Vasiliev
Combine the power of object-oriented PHP and Oracle XML DB.
Generate External Tables from an Excel Spreadsheet Using Apache Jakarta POI[04-Mar-2005]
by Casimir Saternos
Take advantage of open source technology and external tables to load data into Oracle from an Excel spreadsheet.
Installing PHP and the Oracle 10g Instant Client for Linux and Windows [18-Dec-2004]
by Chris Jones
PHP 5, Oracle, and the Future [19-Nov-2004]
by Andi Gutmans
Get an overview of some of the new features in PHP 5—as well as comments on its future for Oracle users—from its release manager.
Master and Commander [19-Nov-2004]
Week 2 of the Mastering J2EE Application Development Series
by Julien Dubois
As a project manager, choosing among project management tools and practices are the most important decisions you will make.
Developing a Project with Oracle JDeveloper 10g and the Maven Plugin [29-Oct-2004]
by Deepak Vohra
Learn how to develop a JDeveloper (Java application) project with the Maven JDeveloper Plugin.
Technical Note: Using PHP to Create Custom SSO Login and Sign-Off Pages [22-Oct-2004]
It's quick and easy to create and manage custom login and sign-off pages for Oracle Application Server Single Sign-On using PHP.
Managing Distributed Trace Files with Oracle and PHP [23-Sept-2004]
by Paul Gallagher
Read this technical case study about the development of a tool that combines the power of PHP and the ease-of-use of PL/SQL for managing distributed trace files through a browser.
In-Container Testing with JUnit and Oracle JDeveloper [24-Aug-2004]
by Julien Dubois
Dubois argues that in-container testing with the JUnit framework is superior to a mock objects approach for integration testing, and explains how to apply those techniques using Oracle JDeveloper.
Set Up Oracle Database 10g and PHP on Mac OS X [10-Aug-2004]
by Matt Rohrer
This guide will help you set up a development workstation with the Oracle Database, PHP compiled with OCI support, and a more productive wrapper for SQL*Plus.
Ant 1.6 for Task Writers [21-July-2004]
by Stefan Bodewig
Take advantage of the changes in Ant 1.6 internals to write a task or even a library of tasks.
The PHP 5 Data Object (PDO) Abstraction Layer and Oracle [28-July-2004]
by Wez Furlong
An overview of the new PHP Data Objects (PDO) data abstraction layer, with a focus on Oracle, from one of its original developers.
New Ant 1.6 Features for Big Projects [24-June-2004]
by Stefan Bodewig
Learn new features of Ant 1.6 and see how they might impact the way you structure your build process.
Scaling Oracle and PHP [18-May-2004]
by George Schlossnagle
Learn generic techniques and designs for writing manageable, scalable, and fast PHP code that directly relate to Oracle Database.
Enterprise Application Development Using PHP and Oracle [02-Apr-2004]
by Kevin Kardasz et al
How McGill University's Department of Development and Alumni Relations supports up to 160,000 users over the web using PHP and Oracle.
PHP and ASP.NET Go Head-to-Head [26-Mar-2004]
by Sean Hull
A point-by-point comparison of price, speed and efficiency, security, and cross-platform support between the two most popular means of building web applications.
New Life for Old Microsoft Access Data [19-Mar-2004]
by Marcel Géagn
Learn how to easily migrate Access data to the Oracle Database on Linux using open-source tools.
Shortening the Distance Between Prototype and Product using PHP [12-Mar-2004]
by John Neil
In Week 2 of the Hitchhiker's Guide to PHP, Myers Internet's chief technical architect explains how a Oracle/PHP development model compressed the application lifecycle for his company's new order-tracking system.
Do You PHP? [01-Mar-2004]
by Rasmus Lerdorf
The creator of PHP kicks off the Hitchhiker's Guide to PHP series by offering his thoughts on the PHP phenomenon.
Setting Up Oracle and PHP on Mac OS X [05-Feb-2004]
by Matt Rohrer
Oracle, Mac OS X, and open source technologies such as PHP and gqlplus make for an enjoyable, productive, and stable development environment. Here's how to set yours up.
Log4plsql: Open-Source Tool for PL/SQL Logging [12-Jan-2004]
by Guillaume Moulard
Logging, an important part of the development lifecycle, is often considered too tedious—but it needn't be.
Back to Top
PL/SQL
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 11g.
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 10g 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.
Migrating to Oracle HTML DB [01-Nov-2005]
by Scott Spendolini
Know when—and when not—to package your PL/SQL.
Picking Your Packages [01-May-2005]
by Steven Feuerstein
Centralize and secure your one-off applications.
Technical Note: Rendering Oracle HTML DB Reports as PDFs Using FOP [18-Mar-2005]
by Kris Rice, Carl Backstrom, Raj Mattamal
Learn how to render Oracle HTML DB report output in PDF, step by step.
Oracle Forms in the SOA World [01-Mar-2005]
by Robin Zimmermann
Oracle Forms can be part of your service-oriented architecture.
Tracing Lines [01-Mar-2005]
by Steven Feuerstein
Analytic functions provide powerful ways to view your data.
Refactoring for PL/SQL Developers [01-Jan-2005]
by Steven Feuerstein
Go beyond identifying PL/SQL practices to create better code.
Wizards Creating Wizards [01-Jan-2005]
by Sergio Leunissen
Use Oracle HTML DB to deliver wizard-based data entry forms.
Technical Note: Using Virtual Private Database in an Oracle HTML DB Application [05-Nov-2004]
See an example of using a Virtual Private Database policy in an HTML DB application.
Better to Best NDS [01-Nov-2004]
by Steven Feuerstein
Best-practice tips for using Native Dynamic SQL in Oracle Database 10g .
Technical Note: Formatting Report Output in Oracle HTML DB Using Report Templates [08-Sep-2004]
Get an overview of report templates in Oracle HTML DB and learn to use them to achieve specific implementation goals.
Controlling Mythological Code [01-Sept-2004]
by Steven Feuerstein
Explode and decode the myths in your code.
The Beauty Is in the Details [23-June-2004]
by Steven Feuerstein
Pay attention to the details in conditions, loops, and declarations, and create better code.
| 
Bookmark
