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

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

How we fill the shopping malls

July 09 2008

I don't go shopping very often. I like to buy things, don't get me wrong. But I don't like to shop, don't like the marketing, the noise, the lines.But when I do go shopping, I am startled by how full the parking lots are and how busy the shops are.After… read more

A confession regarding the Second Amendment

June 27 2008

When I first read of the 5-4 decision by the Supreme Court to explicitly recognize the right of an individual, not a militia, to bear arms, I was dismayed. I still am, but not because I disagreed with them. My dismay is that this decision (really, more the decision to… read more

Always Bulk Collect

June 23 2008

You learn something new every day, right? Well, I certainly do (more or less). Even about PL/SQL, about which I am sure many people think I already know everything. Far from it.   In fact, I learned just last week from the PL/SQL Product Manager, Bryn Llewellyn, that his recommendation regarding cursor… read more

Without logic we are truly lost...

June 07 2008

When I train developers, I like to point out that they (we) are very special people: we use symbolic logic day in and day out to do our jobs. Why does that make us special? Logic forms the foundation not only of software programming, but more generally of "civilization" as… read more

My presentations at Oracle Open World 2008

June 06 2008

In case you are interested, I will be presenting three times at OOW in San Fran this September. The dates/times have not yet been set, but here are the IDs and titles:Session ID: S300183Session Title: Break Your Addiction to SQL!Session ID: S300184Session Title: Weird PL/SQLSession ID: S300185Session Title: Why You… read more

How to Run an OS Command from PL/SQL

June 04 2008

Oracle doesn't make it terribly easy to run operating system commands from within a PL/SQL block. I suppose that's understandable, given that PL/SQL is an embedded database-oriented language. Still, developers do ask me on a regular basis about how they can do this. As I understand it, there are basically three… read more

"Clinton exposes Obama's vulnerability: white voters" DUH!

May 14 2008

Ran across the following article in USA Today, May 13, 2008 - which means of course that I was staying in a hotel. The Forum: Clinton exposes Obama's vulnerability: white votersAnd my reaction? Well, duh....I have to admit that I am surprised and inspired by how far Obama has gotten… read more

Testing and refreshing data from production

April 17 2008

As many of my readers likely know by now, I have been working for the past several years on the Quest Code Tester development effort.   Code Tester is the most powerful PL/SQL test automation tool available. You describe the expected behavior of your programs and Code Tester generates your test code,… read more

Auto-formatting of templates for Toad

April 10 2008

A few months ago, I posted on this blog an explanation of how to use Toad's Code Templates to standardize development and improve productivity. I included an XML document that contains over 20 templates that I thought you might find useful. I also asked my readers to produce XML transformations… read more

Lost (or perhaps gained) in translation

April 09 2008

I ran across a set of dish drain covers in a Puerto Rico supermarket, and found the following text on the back of the package:Chenyang Commodity World UsingWELCOME SHOPPING CHENYANG SE-RIES HARDWARE TOOL ASSEMBLED.THIS SERIES PRODUCT ADOPT ADVA-NCED JOINT PACKING, CLARITY ANDAND HANDSOME,DAMPROOF,CONV-ENIENCE TRANSPORT.THIS SERIES TOOL HAVE COMPLETEVARIETY,CREDIBLE QUALITY,BROADPURPOSE.I especially… read more

Favorite photos....

April 07 2008

I have created a Flickr Set containing some of my favorite photos. I hope you enjoy them!http://www.flickr.com/photos/60694364@N00/sets/72157603882863063/ read more

Battery Water

April 04 2008

We recently installed a solar power system on a house we own in a very sunny clime. Along with the 12 180W solar panels, we have 16 batteries to store all that electricity from the sun. And those batteries need to be topped off with water - water for batteries:… read more
Steven Feuerstein