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 Featu Oracle PL/SQL Programming: Guide to Oracle8i Featu
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)

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

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)

Articles

Blog

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

Analyzing code coverage with the PL/SQL profiler

August 27 2008

I have, for the past several years, focused heavily on designing and building an automated code testing tool for PL/SQL: Quest Code Tester for Oracle. One feature that is often requested as a part of code testing is analysis of code coverage, answering questions like: When I run my program… read more

Butterfly and Leaf - a poem

August 09 2008

(what? You thought I only wrote software? Enjoy....)Butterfly and LeafMoca Finca, August 9, 2008Copyright 2008, Steven FeuersteinFlickering shadowof a butterflycatching the sunseeking out color: Alive, for a time.Fluttering shadowof a leaflosing the sunlosing the branch: Dying, in separation.My eyescan't tell the difference.Living or dying,the shadow is the same.It communicates,it hides.My… read more

Getting weary, so weary: Big Oil's biggest quarter ever: $51.5B in all

August 03 2008

Big Oil sucks us dry once again. By JOHN PORRETTO, AP Business Writer Fri Aug 1, 5:11 PM ETHOUSTON - Oil giants Chevron Corp. and Total SA wrapped up a string of gargantuan, record-breaking earnings reports Friday, a stretch in which six of the major international oil companies topped $50… read more

How to Help Your Company with Financial Risk

July 31 2008

The new SEC standards for SOX compliance have made it clear that your company should spend more time focused on financial risk. In this article, we’ll explore what’s driving this, how you as a database professional can help out, and some design considerations for a Financial Risk Compliance Data Mart. read more

Toad Executing Scripts against Multiple Databases (Part 1)

July 29 2008

One of the more frequent questions people ask me is why can’t Toad run scripts or commands against multiple databases at once? Of course as usual the answer is Toad already can – so I’m going to dedicate the next couple weeks’ blogs to this topic.    This week I’ll highlight the… read more

Automated Storage management

July 29 2008

Continuing on with my discussions on autonomic computing in DB2 is the concept of self managing space. Proper space allocations are another critical factor when it comes to optimizing the performance of your database. Inadequate space allocations can result in application failures and potential downtime which will cost your organization money.   Automated space… read more

Coping with Disaster

July 24 2008

This article wraps up the series on the types of controls and our discussion of architectures, by taking a look at the adaptive control. We’ll explore how you can support your business deal with the impact of risks, when there is no contingency plan. read more

Toad Data Modeler Generates Best SQL

July 23 2008

When you go through the entire exhaustive process of doing an effective (i.e. accurate) logical model so that you have properly captured all the true business rules and requirements, you sure don’t want your data modeling tool to compromise those findings as you move into the physical model – which… read more

Oracle Open World Presentations

July 22 2008

Hey folks,   For anyone attending Oracle Open World this year, here is my schedule of presentations: Session ID: S300184 Session Title: Weird PL/SQL Track: Oracle Develop: Database Room: Golden Gate C3 Date: 2008-09-21 Start Time: 15:45   Session ID: S300183 Session Title: Break Your Addiction to SQL! Track: Oracle Develop: Database Room: Salon 02 Date: 2008-09-22 Start Time: 13:00   Session ID: S300185 Session Title:… read more

Toad...and Java??!!

July 22 2008

I thought that’d grab your attention!   We know there are a lot of PL/SQL developers out there who are looking to make (or have already made) a break into application development using a more popular programming language like Java as well as many Java developers who use Toad to make access… read more

10 Things You Must Know about Toad’s Editor

July 22 2008

The editor window is probably where most users spend a majority of their time. In this blog, I’ll try to highlight the 10 features that will save you the most time when it comes to writing your SQL queries, SQL*Plus scripts, anonymous blocks, and PL/SQL stored procedures. Please note that all of… read more

Oracle Open World Presentations

July 22 2008

Hey folks, For anyone attending Oracle Open World this year, here is my schedule of presentations:  Session ID: S300184 Session Title: Weird PL/SQL Track: Oracle Develop: Database Room: Golden Gate C3 Date: 2008-09-21 Start Time: 15:45 Session ID: S300183 Session Title: Break Your Addiction to SQL! Track: Oracle Develop: Database Room: Salon 02 Date: 2008-09-22 Start Time: 13:00 Session ID: S300185 Session Title: Why… read more

My Oracle Open World Schedule

July 21 2008

Hey folks, For anyone attending Oracle Open World this year, here is my schedule of presentations: Session ID: S300184 Session Title: Weird PL/SQL Track: Oracle Develop: Database Room: Golden Gate C3 Date: 2008-09-21 Start Time: 15:45 Session ID: S300183 Session Title: Break Your Addiction to SQL! Track: Oracle Develop: Database… read more

3 Key Tips for Surviving a Firefight

July 17 2008

Nobody likes a firefighting effort, but unfortunately it’s a fact of life that we need to deal with as database professionals. In this article I share my 3 favorite tips for getting through without getting burned. read more

Only Toad can debug SQL Scripts

July 16 2008

I have been doing Oracle work for just over two decades – and I’ve probably written thousands of SQL scripts. Many of those were DBA oriented in their task nature, but even application development presents times where SQL scripts are used. For example, the need may arise for the operating… read more
Steven Feuerstein