You need to enable JavaScript to view more than 15 articles by this author.
Using PL/SQL Records in SQL Statements
Publish Date: Apr. 22, 2003
The PL/SQL RECORD datatype has been available for years; however, its usefulness was limited because it wasn't possible to use records inside SQL statements. Oracle 9i Release 2 corrects this deficiency. In this final installment in their series on new Oracle 9i features, Steven Feuerstein, coauthor of Oracle PL/SQL Programming, 3rd Edition , and Bryn Llewellyn demonstrate how you can now employ records in UPDATE, INSERT, DELETE, and SELECT statements.
Oracle 9i Release 2 Developments for PL/SQL Collections
Publish Date: Apr. 1, 2003
Steven Feuerstein, coauthor of Oracle PL/SQL Programming, 3rd Edition , and Bryn Llewellyn explore PL/SQL collections in Oracle 9i Release 2, with particular emphasis on associative arrays. This is the latest installment in their continuing series on new Oracle 9i features. Find out why extending the flexibility of the collection
syntax, storage, and access makes it possible to write much simpler, more efficient code than was possible in earlier versions.
HTTP Communication from Within the Oracle Database
Publish Date: Mar. 4, 2003
In this latest installment in their continuing series on new Oracle 9i features, Steven Feuerstein, coauthor of Oracle PL/SQL Programming, 3rd Edition , and Bryn Llewellyn take a look at Utl_Http and show how you can use it in an Oracle 9i database to implement a requestor in a B2B implementation.
Multi-Level Collections in Oracle 9i
Publish Date: Feb. 11, 2003
With Oracle 9i you can have multi-level collections or collections nested within collections. In the next installment in their continuing series on new Oracle 9i features, Steven Feuerstein, coauthor of Oracle PL/SQL Programming, 3rd Edition , and Bryn Llewellyn show how to work with multi-level collections, using examples that progress from the simple to the complex.
Table Functions and Cursor Expressions
Publish Date: Jan. 22, 2003
In their continuing series on new Oracle 9i features, Steven Feuerstein, coauthor of Oracle PL/SQL Programming, 3rd Edition , and Bryn Llewellyn introduce cursor expressions and then show how those expressions can be utilized with table functions.
Native Compilation, CASE, and Dynamic Bulk Binding
Publish Date: Jan. 7, 2003
In Part 4 in his series on new Oracle 9i features, Steven Feuerstein, coauthor of Oracle PL/SQL Programming, 3rd Edition , and Bryn Llewellyn cover native compilation of PL/SQL, CASE statements and CASE expressions, and bulk binding in native dynamic SQL.