Here you will find tutorials and white papers that I've written for Oracle PL/SQL. Please Note most of them are in PowerPoint format.

If you want to link to this page, please feel free to do so. However you cannot reproduce the material here or change it in any way.

PL/SQL Tutorials

Introduction

This is in a PowerPoint format. It gives you an introduction to basics of PL/SQL. It starts of with an explaination of what PL/SQL is, what are its advantages and why you need it. It then goes into language details, such as datatypes, variables, PL/SQL blocks structures, PL/SQL language features including looping constructs and conditional statements and ends with an in-depth look at cursors in PL/SQL (both implicit and explicit).

Format: ZIP file. Size: 76KB.

This is a PowerPoint presentation. It goes into more advanced features of PL/SQL, such as Exceptions and exception handling, Composite Datatypes (including PL/SQL tables and records), stored procedures in PL/SQL (including procedures, functions and packages) and also gives tells you about triggers and how they can be used.

Format: ZIP file. Size: 26KB

This is a white paper, that goes into LOBs in Oracle. It tells you what are LOBs, why you use LOBs, the different types of LOBs, manipulating LOBs through SQL as well as PL/SQL (DMBS_LOB) package etc, along with easy to understand examples. You can also download this paper here as a word document.

Format: ZIP and HTML file. Size: 40KB (HTML) and 19KB (ZIP)

This is a PowerPoint presentation. It explains the various Object Oriented features of PL/SQL and tells you how to work with Object types, from within PL/SQL. It also delves deep into the new Oracle 8 and 8i features, such as Autonomous transactions, Native SQL and Binding etc.

Oracle Pl/Sql Programming		The Oracle Pl/Sql Cd Bookshelf : 7...