Papers and Presentations: Languages

Topic

Title

Slides

Author(s)/Date

PL/SQL & SQL Achieving Great Web Application Performance with only SQL and PL/SQL

Slides

Michael Rosenblum & Dr. Paul Dorsey

10/2011

Implementing Connection Pools for Data-Centric Applications Slides

Michael Rosenblum

6/2010

Performance Tuning Web Applications (updated)

Slides

Dr. Paul Dorsey &

Michael Rosenblum

5/2009

PL./SQL Collections: Processing Datasets Your Way

Slides

Michael Rosenblum

5/2009

Performance Tuning Web Applications

Slides

Dr. Paul Dorsey &

Michael Rosenblum

9/2008

 

Dynamic SQL in a Dynamic World (revised)

Slides

Michael Rosenblum

6/2008

 

Advanced Datatypes: Objects, Collections, LOBs

Slides

Michael Rosenblum

5/2008

 

Dynamic SQL in a Dynamic World

Slides

Michael Rosenblum

5/2008

 

Autonomous Transactions: Extending the Possibilities presented at IOUG

Slides

Michael Rosenblum

4/2008

 

Dynamic SQL: Solving Real World Problems in Real Time   presented at IOUG

Slides

Michael Rosenblum

4/2008

 

Autonomous Transactions: Extending the Possibilities  presented at RMOUG

          Slides

Michael Rosenblum

2/2008

 

StateFULL vs. StateLESS for Database Developers

          Slides

Michael Rosenblum

2/2008

 

Dynamic SQL in a Dynamic World -

The Sequel

          Slides

Michael Rosenblum

2/2008

 

Dynamic SQL and Dynamic PL/SQL

Slides

Dr. Paul Dorsey & Michael Rosenblum

9/2007

 

Making the Most of PL/SQL Collections

Slides

Dr. Paul Dorsey & Michael Rosenblum

9/2007

 

Dynamic SQL in a Dynamic World

Slides

(updated)

Michael Rosenblum

4/2007

 

Dynamic SQL in a Dynamic World

          Slides

Michael Rosenblum

10/2006

 

PL/SQL for Dummies

Slides

Dr. Paul Dorsey & Michael Rosenblum

6/2006

 

Ultra-High Performance SQL and PL/SQL in Batch Processing - revised

Slides

Dr. Paul Dorsey

4/2006

 

Large Issues with Large Objects

Slides

Michael Rosenblum

4/2006

 

Ultra High-Performance SQL & PL/SQL in Batch Processing

          Slides

 

Code Files

Dr. Paul Dorsey & Michael Rosenblum

12/2005

 

Advanced Web-Based Reporting Techniques in PL/SQL

Slides

Michael Rosenblum

6/2004

 

Object Types vs. PL/SQL Tables: 2 Practical Examples

Slides

Michael Rosenblum

6/2004

 

"Fire and Forget": When to Use Autonomous Transactions

Slides

Michael Rosenblum

9/2002

 

Simulating ROLLBACK TO SAVEPOINT Behavior in the Database Trigger

 

submitted by Zlatko Sirotic, Istra informaticki inzenjering - Croatia

INSTEAD-OF Trigger Views to Support Application Development

Slides

Dr. Paul Dorsey

6/2001

 

Building an API Using PL/SQL Packages and Updateable Views

Slides

John C. Lennon

10/2000

Understanding Oracle's External Procedure Architecture for PL/SQL

Slides

Robert F. Edwards

6/2000

Coding on the Fly: Using the Execute Immediate Procedure

Dr. Paul Dorsey & 

Yalim Gerger

2/2000

Introduction to PL/SQL

Slides

John C. Lennon

6/2000

Functional Magic II: Dynamically Enforcing Foreign Key Delete Constraints on the Client

John C. Lennon

6/2000

In Pursuit of PL/SQL Programming Excellence

John C. Lennon

6/2000

 

 

 

 

Java

Repository-Based J2EE Development

Slides

Dr. Paul Dorsey

2/2006

 

Making a non-Trivial Java Bean Work

Slides

Ileana Balcu

6/2004

 

Building Java Applications Using Oracle 9i JDeveloper

Slides

Dr. Paul Dorsey

11/2003

 

Java Stored Procedures: An Alternative to External Procedures?

Slides

Robert F. Edwards

11/2002

 

Introduction to Java for PL/SQL Programmers

Slides

Dr. Paul Dorsey

9/2000

 

Creating a Highly Productive Java-Based Development Environment

Slides

Dr. Paul Dorsey

11/1999

 

Creating a Highly Productive Java-Based Development Environment 2

Slides

Dr. Paul Dorsey

8/2000