Quantcast
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 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 from O'Reilly Media). Steven has been developing software since 1980, spent five years with Oracle (1987-1992) and serves as PL/SQL Evangelist for Quest Software. His Oracle PL/SQL Best Practices column is one of the more popular destinations on the Oracle Technology Network and he writes regularly for Oracle Magazine. Steven believes that unit testing is one of the most critical challenges facing PL/SQL developers and has been developing Quest Code Tester for Oracle to meet that challenge (www.quest.com/code-tester-for-oracle).

Books

Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Language Pocket Reference
by Steven Feuerstein , Bill Pribyl , Chip Dawes
Fourth Edition October 2007
$14.99 USD
starstarstarstarstar
(Read Reviews)

Oracle PL/SQL Best Practices Oracle PL/SQL Best Practices
by Steven Feuerstein
Second Edition October 2007
$29.99 USD
starstarstarstarstar
(Read Reviews)

MySQL Stored Procedure Programming MySQL Stored Procedure Programming
by Guy Harrison , Steven Feuerstein
March 2006
$44.99 USD
starstarstarstarstar
(Read Reviews)

Oracle PL/SQL for DBAs Oracle PL/SQL for DBAs
by Arup Nanda , Steven Feuerstein
October 2005
$39.95 USD

Oracle PL/SQL Programming Oracle PL/SQL Programming
by Steven Feuerstein , Bill Pribyl
Fourth Edition August 2005
$64.95 USD
starstarstarstarstar
(Read Reviews)

Oracle PL/SQL Language Pocket Reference 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 Oracle PL/SQL Language Pocket Reference
by Steven Feuerstein , Bill Pribyl , Chip Dawes
Second Edition February 2003
OUT OF PRINT
starstarstarstarstar
(Read Reviews)

Oracle PL/SQL Programming Oracle PL/SQL Programming
by Steven Feuerstein
Third Edition September 2002
OUT OF PRINT
starstarstarstarstar
(Read Reviews)

Learning Oracle PL/SQL Learning Oracle PL/SQL
by Bill Pribyl
November 2001
$49.99 USD
starstarstarstarstar
(Read Reviews)

Oracle PL/SQL Best Practices Oracle PL/SQL Best Practices
by Steven Feuerstein
April 2001
OUT OF PRINT
starstarstarstarstar
(Read Reviews)

Oracle PL/SQL Programming: A Developer's Workbook Oracle PL/SQL Programming: A Developer's Workbook
by Steven Feuerstein , Andrew Odewahn
May 2000
$49.99 USD
starstarstarstarstar
(Read Reviews)

Oracle PL/SQL Programming: Guide to Oracle8i Features Oracle PL/SQL Programming: Guide to Oracle8i Features
by Steven Feuerstein
October 1999
OUT OF PRINT
starstarstarstarstar
(Read Reviews)

Oracle PL/SQL Language Pocket Reference 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 Oracle PL/SQL Built-ins Pocket Reference
by Steven Feuerstein , John Beresniewicz , Chip Dawes
October 1998
OUT OF PRINT
starstarstarstarstar
(Read Reviews)

Oracle Built-in Packages Oracle Built-in Packages
by Steven Feuerstein , Charles Dye , John Beresniewicz
May 1998
$49.95 USD
starstarstarstarstar
(Read Reviews)

Oracle PL/SQL Programming Oracle PL/SQL Programming
by Steven Feuerstein
Second Edition September 1997
OUT OF PRINT
starstarstarstarstar
(Read Reviews)

Advanced Oracle PL/SQL Programming with Packages Advanced Oracle PL/SQL Programming with Packages
by Steven Feuerstein
January 1900
OUT OF PRINT
starstarstarstarstar
(Read Reviews)

Oracle PL/SQL Programming Oracle PL/SQL Programming
by Steven Feuerstein
January 1900
OUT OF PRINT

Articles

Blog

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

Doing SQL in PL/SQL: a key resource from Bryn Llewellyn

October 08 2008

One of the highlights of Oracle Open World 2008 for me was the presentation by Bryn Llewellyn (PL/SQL Product Manager) on 'Doing SQL in PL/SQL: best and worst practices.'Bryn surely has the most thorough and clear understanding of the PL/SQL language of anyone I have met (definitely including me).His talk… read more

Doing SQL in PL/SQL: key resource from Bryn Llewellyn

October 08 2008

One of the highlights of Oracle Open World 2008 for me was the presentation by Bryn Llewellyn (PL/SQL Product Manager) on “Doing SQL in PL/SQL.”   Bryn surely has the most thorough and clear understanding of the PL/SQL language of anyone I have met (definitely including me).   His talk was detailed and precise… read more

Quick Tip: Oracle11g function result cache

October 05 2008

I just realized it's been a little while since I offered some PL/SQL thoughts on this blog. Sorry, the election campaign is twisting around my priorities. So how about if I share with you what I believe is far and away the most important new feature for PL/SQL developers in… read more

It’s the Little Things…

October 03 2008

We often spend a lot of time trumpeting the sexy little widgets in our database tools and overlook the little things that really aid in the development of our applications or even just writing the mundane queries that fill up our day. I’d like to just spend a quick 10 minutes… read more

Control Convergence by Example

October 03 2008

Control convergence – the effort of staying in compliance while reducing the number of controls – is a big trend in the industry today. In this article, we demonstrate how the data professional can support a control convergence effort, by way of fictitious case study. read more

Sarah Palin, the lipstick-coated, pitbull-mannered Stepford Wife

October 03 2008

I watched the VP debate. Yep, there is no doubt about it: we now know that if Sarah Palin is given a month to prepare for a debate, then she will not totally screw things up. In fact, what we found is that she will be able to pretty much… read more

Could they at least APOLOGIZE for f#@king up our country?

September 30 2008

For years now, people on the left have declared the US economy a "house of cards" built on debt and by transferring wealth from the middle class and poor to the rich. I include myself in this group, as you can verify by reading back through my blog.And for those… read more

Compelling Features for Upgrading to Toad v9.7

September 25 2008

So, another version of Toad has been released. It happens a few times a year. If you’re lucky it’s up to you if and when you want to upgrade to get your bug fixes or new features. If you’re in a larger organization, there’s a standards committee that decides who gets what when. I… read more

Policy Data Management in 3 Stages

September 25 2008

In this article, we talk about policies – an important area of your companies governance, risk, and compliance program. We discuss what a good policy looks like, and how you can evolve a policy data management system in 3 stages. read more

Configuring Toad’s Team Coding with Subversion

September 23 2008

With Toad for Oracle 9.7 now available, I thought I’d cover how to configure and use Subversion with Toad’s code sharing utility – Team Coding. We had a lot of requests for this integration and here it is !   The Subversion implementation in Toad allows you to use the conventional file-based… read more

For loops or While loops to scan collections?

September 22 2008

I have generally recommended in the past that whenever you are writing code to iterate through the elements of a collection, you should use a while loop, combined with the FIRST-NEXT or LAST-PRIOR collection methods.   The key advantage of this approach is that the code will not raise a NO_DATA_FOUND exception… read more

Now part of Toad for Oracle: Toad for Data Analysis!

September 19 2008

Toad for Data Analysis now comes included with Toad for Oracle! read more

People Make Mistakes

September 18 2008

Human beings, by their very nature, make mistakes. Even seasoned professionals make simple errors on occasion. In this article we explore the “mistake database”, an architecture to help your company minimize errors. read more

RAC the Casba

September 17 2008

On many occasions, people will email or call me to get help with perceived RAC connectivity issues for various client applications – Toad and other Quest products included. Now some times they may have setups that we’ve not pre-tested, so they have a potential bug – or at least another… read more

Another aspect of the Bush Legacy

September 14 2008

A world-wide race to arm rather than feed our citizens....US in push for arms dealsThe Times, citing Defense Department sales data through the end of August, reported that countries newly reliant on the United States as a primary major weapons source included Argentina, Brazil, India, Iraq, Morocco and Pakistan and… read more
Steven Feuerstein