Carview!

CARVIEW

MOTORHOMES

Select Language

HTTP/2 302 server: nginx date: Sun, 03 Aug 2025 07:55:25 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20100209013719 location: https://web.archive.org/web/20100209013719/https://oreilly.com/pub/au/344 server-timing: captures_list;dur=0.674859, exclusion.robots;dur=0.023261, exclusion.robots.policy;dur=0.010727, esindex;dur=0.016809, cdx.remote;dur=218.524244, LoadShardBlock;dur=181.432715, PetaboxLoader3.datanode;dur=60.089149, PetaboxLoader3.resolve;dur=79.528084 x-app-server: wwwb-app216 x-ts: 302 x-tr: 435 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 set-cookie: wb-p-SERVER=wwwb-app216; path=/ x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() HTTP/2 301 server: nginx date: Sun, 03 Aug 2025 07:55:25 GMT content-type: text/html; charset=iso-8859-1 content-length: 305 x-archive-orig-date: Tue, 09 Feb 2010 01:37:18 GMT x-archive-orig-server: Apache location: https://web.archive.org/web/20100209013719/https://www.oreillynet.com/pub/au/344 x-archive-orig-content-length: 305 x-archive-orig-connection: close cache-control: max-age=1800 memento-datetime: Tue, 09 Feb 2010 01:37:19 GMT link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate", ; rel="first memento"; datetime="Sun, 22 Jun 2003 01:59:16 GMT", ; rel="prev memento"; datetime="Sun, 22 Mar 2009 23:55:56 GMT", ; rel="memento"; datetime="Tue, 09 Feb 2010 01:37:19 GMT", ; rel="next memento"; datetime="Wed, 10 Feb 2010 11:51:55 GMT", ; rel="last memento"; datetime="Mon, 25 Nov 2024 02:07:11 GMT" content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org x-archive-src: 52_14_20100209001820_crawl100-c/52_14_20100209013622_crawl100.arc.gz server-timing: captures_list;dur=0.511404, exclusion.robots;dur=0.019396, exclusion.robots.policy;dur=0.009045, esindex;dur=0.010572, cdx.remote;dur=33.270948, LoadShardBlock;dur=195.600159, PetaboxLoader3.resolve;dur=223.425040, PetaboxLoader3.datanode;dur=95.334884, load_resource;dur=147.085926 x-app-server: wwwb-app216 x-ts: 301 x-tr: 413 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() HTTP/2 302 server: nginx date: Sun, 03 Aug 2025 07:55:26 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20100209001239 location: https://web.archive.org/web/20100209001239/https://www.oreillynet.com/pub/au/344 server-timing: captures_list;dur=0.535414, exclusion.robots;dur=0.020396, exclusion.robots.policy;dur=0.009792, esindex;dur=0.011733, cdx.remote;dur=33.267884, LoadShardBlock;dur=372.937549, PetaboxLoader3.datanode;dur=56.438850, PetaboxLoader3.resolve;dur=127.553178 x-app-server: wwwb-app216 x-ts: 302 x-tr: 449 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() HTTP/2 200 server: nginx date: Sun, 03 Aug 2025 07:55:27 GMT content-type: text/html; charset=UTF-8 x-archive-orig-date: Tue, 09 Feb 2010 00:12:39 GMT x-archive-orig-server: Apache x-archive-orig-p3p: policyref="https://www.oreillynet.com/w3c/p3p.xml",CP="CAO DSP COR CURa ADMa DEVa TAIa PSAa PSDa IVAa IVDa CONo OUR DELa PUBi OTRa IND PHY ONL UNI PUR COM NAV INT DEM CNT STA PRE" x-archive-orig-connection: close x-archive-guessed-content-type: text/html x-archive-guessed-charset: iso-8859-4 memento-datetime: Tue, 09 Feb 2010 00:12:39 GMT link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate", ; rel="first memento"; datetime="Fri, 15 Nov 2002 19:38:33 GMT", ; rel="prev memento"; datetime="Mon, 11 Jan 2010 02:36:11 GMT", ; rel="memento"; datetime="Tue, 09 Feb 2010 00:12:39 GMT", ; rel="next memento"; datetime="Thu, 11 Feb 2010 10:04:22 GMT", ; rel="last memento"; datetime="Thu, 15 Apr 2021 08:20:37 GMT" content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org x-archive-src: TLA-20100209000040-00223-ia360904-c/TLA-20100209000758-00414-ia360906.us.archive.org.warc.gz server-timing: captures_list;dur=2.367787, exclusion.robots;dur=0.026295, exclusion.robots.policy;dur=0.012269, esindex;dur=0.015398, cdx.remote;dur=31.349285, LoadShardBlock;dur=300.599711, PetaboxLoader3.datanode;dur=109.552637, PetaboxLoader3.resolve;dur=369.510366, load_resource;dur=355.198884 x-app-server: wwwb-app216 x-ts: 200 x-tr: 850 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() content-encoding: gzip Steven Feuerstein

Steven Feuerstein

Oracle PL/SQL expert, evangelist, author and trainer

Areas of Expertise:

PL/SQL
Oracle
stored procedures
consulting

speaking
training
writing

Biography

Steven Feuerstein is considered to be one of the world's leading experts on the Oracle PL/SQL language, having written ten books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all published by O'Reilly Media). Steven has been developing software since 1980, spent five years with Oracle (1987-1992), and has served as PL/SQL Evangelist for Quest Software since January 2001. He is an Oracle ACE Director and writes regularly for Oracle Magazine, which named him the PL/SQL Developer of the Year in both 2002 and 2006. He is also the first recipient of ODTUG's Lifetime Achievement Award (2009). Since 2005 he has focused his attention on improving the testing of PL/SQL programs, primarily through the creation of Quest Code Tester for Oracle, which automates PL/SQL code testing. Steven's online technical cyberhome is located at www.ToadWorld.com/SF. You can also catch up on his latest, mostly non-PLSQL rants at https://feuerthoughts.blogspot.com.

Books

Oracle PL/SQL Programming by Steven Feuerstein , Bill Pribyl Fifth Edition September 2009 Print: $69.99 Ebook: $55.99	Oracle PL/SQL Language Pocket Reference by Steven Feuerstein , Bill Pribyl , Chip Dawes Fourth Edition October 2007 Print: $14.99 Ebook: $11.99 (5) (Read Reviews)
Oracle PL/SQL Best Practices by Steven Feuerstein Second Edition October 2007 Print: $29.99 Ebook: $23.99 (5) (Read Reviews)	MySQL Stored Procedure Programming by Guy Harrison , Steven Feuerstein March 2006 Print: $44.99 Ebook: $35.99 (5) (Read Reviews)
Oracle PL/SQL for DBAs by Arup Nanda , Steven Feuerstein October 2005 Print: $39.95 Ebook: $31.99	Oracle PL/SQL Programming by Steven Feuerstein , Bill Pribyl Fourth Edition August 2005 OUT OF PRINT (4) (Read Reviews)
Oracle PL/SQL Language Pocket Reference by Steven Feuerstein , Bill Pribyl , Chip Dawes Third Edition April 2004 OUT OF PRINT	Oracle PL/SQL Language Pocket Reference by Steven Feuerstein , Bill Pribyl , Chip Dawes Second Edition February 2003 OUT OF PRINT (4) (Read Reviews)
Oracle PL/SQL Programming by Steven Feuerstein Third Edition September 2002 OUT OF PRINT (5) (Read Reviews)	Learning Oracle PL/SQL by Bill Pribyl November 2001 Print: $49.99 Ebook: $39.99 (4) (Read Reviews)
Oracle PL/SQL Best Practices by Steven Feuerstein April 2001 OUT OF PRINT (5) (Read Reviews)	Oracle PL/SQL Programming: A Developer's Workbook by Steven Feuerstein , Andrew Odewahn May 2000 Print: $54.99 Ebook: $43.99 (4) (Read Reviews)
Oracle PL/SQL Programming: Guide to Oracle8i Featu by Steven Feuerstein October 1999 OUT OF PRINT (5) (Read Reviews)	Oracle PL/SQL Language Pocket Reference by Bill Pribyl , Steven Feuerstein , Chip Dawes April 1999 OUT OF PRINT (Read Reviews)
Oracle PL/SQL Built-ins Pocket Reference by Steven Feuerstein , John Beresniewicz , Chip Dawes October 1998 OUT OF PRINT (3) (Read Reviews)	Oracle Built-in Packages by Steven Feuerstein , Charles Dye , John Beresniewicz May 1998 Print: $49.95 (5) (Read Reviews)
Oracle PL/SQL Programming by Steven Feuerstein Second Edition September 1997 OUT OF PRINT (4) (Read Reviews)	Advanced Oracle PL/SQL Programming with Packages by Steven Feuerstein October 1996 OUT OF PRINT (1) (Read Reviews)
Oracle PL/SQL Programming by Steven Feuerstein September 1993 OUT OF PRINT

Articles

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, 2003The 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, 2003Steven 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, 2003In 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, 2003With 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, 2003In 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, 2003In 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. New Datatypes, New Possibilities
Publish Date: Dec. 9, 2002In Part 3 in his series on new Oracle 9i features, Steven Feuerstein, coauthor of Oracle PL/SQL Programming, 3rd Edition, looks at some of Oracle's new datatypes and shows how you can make them work for you. Substituting and Converting Object Types in a Hierarchy
Publish Date: Nov. 12, 2002In Part 2 in his series on new Oracle 9i features, Steven Feuerstein, coauthor of Oracle PL/SQL Programming, 3rd Edition, explores the advantages and flexibilities of object-type hierarchies by examining substitutability and type conversion. Inherit the Database: Oracle9i's Support for Object Type Inheritance
Publish Date: Oct. 29, 2002Steven Feuerstein, coauthor of Oracle PL/SQL Programming, 3rd Edition, offers a quick review of object types and then shows how you can build object-type hierarchies by taking advantage of inheritance. This is the first installment in an eight-part series on new Oracle 9i features. Not All Best Practices Are Created Equal
Publish Date: Apr. 2, 2001O'Reilly author offers his best of the best of Oracle PL/SQL Practices. By Steven Feuerstein, author of O'Reilly's Oracle PL/SQL Best Practices (April 2001). A Unit Testing Framework for Oracle PL/SQL-- What's New
Publish Date: Mar. 20, 2001utPLSQL Update The Importance of Unit Testing
Publish Date: Jan. 2, 2001A unit test is a test that a developer creates to ensure that his or her "unit", usually a single program, works properly. A unit test is very different from a system or functional test; these latter types of test are oriented to application features or overall testing of the system. You cannot properly or effectively perform a system test until you know that the individual programs behave as expected. The utPLSQL Project
Publish Date: Jan. 1, 2001utPLSQL is an open source, unit-testing framework for Oracle PL/SQL developers. Created by Steven Feuerstein, author of several classic PL/SQL books and a leading PL/SQL trainer, utPLSQL is being developed as open source, consistent with the lightweight development methodology known as Extreme Programming. Aw, Gee, Mom, Do I Have to Test My Code?
Publish Date: Jun. 1, 2000I don't really like to have to take the time to test my software (nor do I like to write documentation for it). I do it, but I don't ever really do enough of it. And I have this funny feeling that I am not alone. The overwhelming reality is that developers generally perform an inadequate number of inadequate tests and figure that if the users don't find a bug, there is no bug. Why does this happen? Let me count the ways...

Blog

Steven's blog posts are hosted at:
https://feuerthoughts.blogspot.com
https://www.toadworld.com/sf

Book Review: Toad Handbook, 2nd Edition

December 31 2009

An exhaustive look at Toad, that doesn’t take that long to read and see immediate improvement in your day-to-day use of the tool. If you are new to Toad, this will shorten the learning curve. If you have been using Toad for 10 years, this will ensure you are not… read more

Migrating your BMF Repository

December 30 2009

This blog will give you the necessary steps?to migrate your MySQL BMF repository to another database of your choice. The following databases are supported by BMF: Oracle, SQL Server, MySQL and Sybase. We will be using the Data Migration Wizard that is provided to us by BMF. The first step is… read more

Serena Williams beats out horse to win 2009 AP Female Athlete of Year

December 22 2009

Serena Williams received 66 of 158 votes to be selected as the 2009 AP Female Athlete of the Year. I like Serena. I like to watch her play. I like to watch her curse at referees. So I checked out this article on the big news.And I scanned through the… read more

TOAD Database Connections Problems

December 21 2009

One of the most common TOAD questions or problem areas is with connecting to remote and/or local databases. The process and requirements are actually quite simple – yet this remains a high frequency question that seems to cause remarkable confusion. And not just for new Oracle or new TOAD users,… read more

How to reference IN argument values in outcomes

December 21 2009

Sometimes you need to reference the value of an IN argument (an input, in Code Tester terminology) in your outcome. For example, under certain circumstances, the string returned by your function should be the same as the input value. Or perhaps the out value should be some part of the… read more

An amazing way to visit Prague without leaving your computer

December 19 2009

Prague is one of my favorite cities - my friends at Oracle (and now beyond Oracle - a "shout out" to Petra, Martin, Roman, Monique, Lenka...) have always taken such good care of me; the sidewalks are nothing short of amazing - yes, the sidewalks; great restaurants; beautiful bridges and… read more

Toad? for Oracle 10.1 Updates

December 17 2009

For those of you who haven’t yet upgraded to Toad 10, or were perhaps waiting until the first minor release, here’s a quick synopsis of what really characterizes Toad 10. ? Toad for Oracle v10 offers new features and many enhancements to existing features, all of it designed to augment your workflow… read more

Toad for DB2 LUW and Spotlight on DB2 LUW play well together

December 15 2009

Did you know that you can call Spotlight on DB2 LUW from Toad for DB2 LUW and vice versa??Well, ok maybe you did.?If that’s the case, please move along, there’s nothing to see here.?Still with me??Then read on! Toad for DB2 LUW and Spotlight on DB2 LUW exist as separate… read more

Really Cool 'TOAD-Like' Freeware

December 14 2009

We all love TOAD – both the commercial and freeware versions. We love it because it’s simply the best Oracle productivity enhancing tool out there. A few weeks back, I mentioned the many other freeware offerings from Quest. So this week I thought I’d mention a few other freeware offerings… read more

Importing and exporting TOAD Report Manager Reports

December 14 2009

Step by step instructions for importing and exporting TOAD Report Manager reports (TRD -TOAD Report Definition format). read more

Why Toad?

December 09 2009

Toad for Oracle is a world-class enterprise query-develop-tune-administration tool for the Oracle database platform.?This document attempts to differentiate Toad from the average Oracle IDE or query tool so that the reader can make an informed decision to invest in the Toad product family. Following is a list of features and concepts… read more

Today is One of My Favorite Days of the Year

December 09 2009

Today, December 9, 2009, is one of my favorite days of the year. Why is that? Because it marks the very last time in 2009 that I will be in airplane and be at O'Hare Airport.Yes, with three weeks to spare, I will not do any more flying in 2009.Sadly,… read more

Execute TOAD Scripts on Multiple Databases

December 07 2009

Many TOAD users ask “How can I run my SQL script against a collection or even all my databases all at once (i.e. in a single step)?” The problem is they generally ask this question while in the Editor – which by definition works with but a single active database… read more

Quest Database Freeware

November 30 2009

Often database professionals need good freeware tools to get their job done. Sometimes it’s because there’s no funding for software. And in some cases a tool is needed to replace the purchased tool that ends up not being able to do the job. Finally in today’s world of open source,… read more

Investigating and Managing Differences with SQL Navigator

November 23 2009

Quest Software has two of the most powerful tools for PL/SQL development:?Toad for Oracle and SQL Navigator for Oracle.?Personally, I spend more time working with Toad for Oracle and I truly enjoy the solution.?Before I proceed any further, I want to clarify a point.?I am not advocating one solution over… read more

"If you are responsible for PL/SQL coding, this book needs to be on your desk. Period. "
--Michael Wehrle, Amazon.com

Original Source | Taken Source

O'Reilly Community

Biography

Books

Articles

Blog

Hire Steven Feuerstein

Also find Steven on:

Buy Now and Save

Bundle Your Order