Presentation: New PL/SQL Features in Action (PDF) Presented as paper #32501 at OracleWorld, San Francisco, Nov 2002 Both Oracle9i Database Release 1 and Release 2 introduced powerful new PL/SQL features. In this paper, we focus on just two: Native compilation of PL/SQL; and index-by-varchar2 tables. We will review the details of these enhancements and provide complete code samples to enable you to understand them and to test thier performance.
White Paper: Less Pain, More Gain (PDF) Use the new PL/SQL features in Oracle9i Database to get better programs by writing fewer code lines.
Presentation: Less Pain, More Gain (PDF) Presented as paper #30720 at OracleWorld, Copenhagen, June 2002 Both Oracle9i Database Release 1 and Release 2 introduced powerful new PL/SQL language features. These allow you to implement your required functionality using compact syntax backed by an efficient implementation. This paper will examine some very common programming tasks. We'll remind you how you would have had to implement them in versions prior to Oracle9i Database. And we'll show you the new recommended approach. You'll see that you need fewer lines of code. We'll explain why the program will be more efficient. Another reason you often used to write more code than you wanted was to call Dbms_Output.Put_Line, the de facto debugging tool of choice. We'll demonstrate how you can now forget that and debug your programs interactively using Oracle9i JDeveloper's graphical PL/SQL development environment.
PL/SQL in Oracle9i Database Release 1
Script: Upgrade an exsiting Oracle9i Database to all NATIVE (HTML) To get the best advantage from NATIVE compilation, compile all your PL/SQL units NATIVE.
Presentation: PL/SQL Enhancements in Oracle9i (PDF) Presented as paper #129 at OOW, San Francisco, Dec. 2001 Leverage architecture changes, especially native compilation, to boost performance. Learn about bulk binding enhancements: exception handling with bulk binding; bulk binding in native dynamic SQL. Learn about: table functions and cursor expressions; multilevel collections; enhancements to the Utl_Http package; CASE statements and CASE expressions.
White Paper: Best Practices in PSP Development (PDF) This paper presents guideline for best practice in the development of PL/SQL Server Pages (aka PSPs). It also explains what a PSP is, and gives guidelines for deciding whether to implement a browser page as a PSP or as a hand-written PL/SQL procedure. Though it was commissioned as one of a set of best practices papers for Oracle9iAS, it is equally applicable for applications which use the webserver which is shipped with Oracle9i Database.
PL/SQL New Oracle9i Features: Documentation (HTML)
PL/SQL in Oracle8i
Presentation: Techniques for Developing Faster PL/SQL Applications (PDF) This presentation describes several reasons for poor execution speed, and corrective actions to take.
Presentation: Application Development using Oracle8i PL/SQL (PDF) This presentation describes features that make development with Oracle8i PL/SQL easier and better.
Presentation: Web Enabling PL/SQL Based Database Applications (PDF) This presentation describes various options and features that enable you to Web enable PL/SQL applications.
New Features for Oracle8i PL/SQL (HTML) With Oracle8i, Oracle significantly enhanced PL/SQL to address customer needs in the areas of performance, application development, and Java integration.