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. He is the author or coauthor of Oracle PL/SQL Programming, Oracle PL/SQL Best Practices, Oracle PL/SQL Programming: Guide to Oracle8i Features, Oracle PL/SQL Developer's Workbook, Oracle Built-in Packages, Advanced Oracle PL/SQL Programming with Packages, and several pocket reference books (all from O'Reilly & Associates). Steven is a Senior Technology Advisor with Quest Software, has been developing software since 1980, and worked for Oracle Corporation from 1987 to 1992.

Books

Oracle PL/SQL Programming Oracle PL/SQL Programming
by Steven Feuerstein , Bill Pribyl
Fifth Edition September 2009 (est.)
Print: $69.99

Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Language Pocket Reference
by Steven Feuerstein , Bill Pribyl , Chip Dawes
Fourth Edition October 2007
Print: $14.99
Ebook: $11.99
Bundle: $19.49
starstarstarstarstar (5)
(Read Reviews)

Oracle PL/SQL Best Practices Oracle PL/SQL Best Practices
by Steven Feuerstein
Second Edition October 2007
Print: $29.99
Ebook: $23.99
Bundle: $38.99
starstarstarstarstar (5)
(Read Reviews)

MySQL Stored Procedure Programming MySQL Stored Procedure Programming
by Guy Harrison , Steven Feuerstein
March 2006
Print: $44.99
Ebook: $35.99
Bundle: $58.49
starstarstarstarstar (5)
(Read Reviews)

Oracle PL/SQL for DBAs Oracle PL/SQL for DBAs
by Arup Nanda , Steven Feuerstein
October 2005
Print: $39.95
Ebook: $31.99
Bundle: $51.94

Oracle PL/SQL Programming Oracle PL/SQL Programming
by Steven Feuerstein , Bill Pribyl
Fourth Edition August 2005
Print: $64.95
Ebook: $51.99
Bundle: $84.44
starstarstarstarstar (4)
(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 (4)
(Read Reviews)

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

Learning Oracle PL/SQL Learning Oracle PL/SQL
by Bill Pribyl
November 2001
Print: $49.99
Ebook: $39.99
Bundle: $64.99
starstarstarstarstar (4)
(Read Reviews)

Oracle PL/SQL Best Practices Oracle PL/SQL Best Practices
by Steven Feuerstein
April 2001
OUT OF PRINT
starstarstarstarstar (5)
(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
Print: $54.99
Ebook: $39.99
Bundle: $71.49
starstarstarstarstar (4)
(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 (5)
(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 (3)
(Read Reviews)

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

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

Advanced Oracle PL/SQL Programming with Packages Advanced Oracle PL/SQL Programming with Packages
by Steven Feuerstein
October 1996
OUT OF PRINT
starstarstarstarstar (1)
(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

Another most excellent ODTUG

June 26 2009

I am just back from the latest ODTUG (the Oracle Development Tools User Group) Kaleidoscope conference, this time in Monterey, California. It was, as usual, a very well-run and successful event (their attendance actually grew from 2008, which is saying an awful lot given the state of the global economy).It… read more

Oracle PL/SQL Programming 5th Edition - "Early Warning"

June 10 2009

I was on the phone with a Quest Code Tester user the other day and he asked me if I was working on the next edition of my original "magnum opus", Oracle PL/SQL Programming, which would include Oracle11g features.   I cannot describe to you how good it felt to say: "No,… read more

Oracle PL/SQL Programming 5th Edition - "Early Warning"

June 10 2009

I was on the phone with a Quest Code Tester user the other day and he asked me if I was working on the next edition of my original "magnum opus", Oracle PL/SQL Programming, which would include Oracle11g features.   I cannot describe to you how good it felt to say: "No,… read more

Quest Code Tester for Oracle 1.8.3 Now Available

June 10 2009

Version 1.8.3 of Quest Code Tester (the most powerful automated testing tool for PL/SQL currently available, and my main obsession these days) is now available for downloading from Quest's on-line SupportLink (after being prompted to log in you will be taken directly to the download page). If you write PL/SQL… read more

Hurrah for Barack Obama: another step towards normalization with Cuba

June 03 2009

How very exciting! The U.S. policy towards Cuba has been an obscenity for decades, even to the extent of supporting and allowing acts of terrorism on our own soil by so-called Gusanos (worms) against other Cubans supporting the Castro government. Normalization with Cuba would be a big step towards a… read more

Force me to take a break, will you?

June 03 2009

Two of the biggest problems we developers have are (a) we are addicted to writing software and don't want to stop, and (b) we generally think we're pretty sharp people and can solve any problem that comes our way.Why are these problems? Because the net result is that we tend… read more

Naming Conventions and Coding Standards, the Feuerstein Way

May 28 2009

I am often asked about the naming conventions and coding standards that I use. My answer is usually a combination of muttering and vague statements and hand-waving.   That's because I have a confession: I don't have a single naming conventions and coding standards document that I use. Why not? Because I… read more

Naming Conventions and Coding Standards, the Feuerstein Way

May 28 2009

I am often asked about the naming conventions and coding standards that I use. My answer is usually a combination of muttering and vague statements and hand-waving.   That's because I have a confession: I don't have a single naming conventions and coding standards document that I use. Why not? Because I… read more

Naming Conventions and Coding Standards, the Feuerstein Way

May 28 2009

I am often asked about the naming conventions and coding standards that I use. My answer is usually a combination of muttering and vague statements and hand-waving.That's because I have a confession: I don't have a single naming conventions and coding standards document that I use. Why not? Because I… read more

Why can't Dick Cheney just sink back into his "undisclosed location"?

May 21 2009

How strange. When Dick Cheney was the Vice President and, many argue, the main force behind the Bush Administration's policies, he was largely invisible, holed up in an "undisclosed location" and acting is an un-democractic a fashion as seemed possible.Then his party loses the election, in large part precisely because… read more

New blog on Quest Code Tester

May 21 2009

As you may know, besides writing about and playing with PL/SQL, I have helped create an automated testing tool for PL/SQL code name Quest Code Tester for Oracle. If you have any intention of methodically and repeatedly testing the code you write, Code Tester is without doubt the best option… read more

Advice for dealing with ridiculous interview questions

May 02 2009

I received an email last week with this question: "What is the maximum number of triggers that can be defined on a single table?"My answer was: "Heck if I know. Check the Oracle documentation."To which he replied: "Actually Oracle documentation does not mention anything about this. But this a favorite… read more

iPorn - are 100000000 "apps" really what we need now?

April 30 2009

A friend of mine recently wrote to me:"I just spent 2 hours on the phone with Apple to get Outlook to sync calendars with my iPhone (still not done but I hope successful); now that will get you confused and wondering about your sanity for wanting that sexy phone..."I wrote… read more

A Classic Error in My Monthly Puzzle!

April 27 2009

Every month, a Toad World newsletter goes out to thousands of Toad users and it includes a monthly puzzle that I write. Last month's puzzle went like this: Which of the following blocks does not contain an infinite loop? A. DECLARE    l_line VARCHAR2(32767);    l_file UTL_FILE.file_type :=       UTL_FILE.fopen ('C:\temp', 'my_file.txt', 'R'); BEGIN    LOOP       UTL_FILE.get_line (l_file,… read more

A Classic Error in My Monthly Puzzle!

April 27 2009

Every month, a Toad World newsletter goes out to thousands of Toad users and it includes a monthly puzzle that I write. Last month's puzzle went like this: Which of the following blocks does not contain an infinite loop? A. DECLARE    l_line VARCHAR2(32767);    l_file UTL_FILE.file_type :=       UTL_FILE.fopen ('C:\temp', 'my_file.txt', 'R'); BEGIN    LOOP       UTL_FILE.get_line (l_file,… read more
Steven Feuerstein

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