Oracle PL/SQL expert, evangelist, author and trainer
Areas of Expertise:
- stored procedures
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). Steven's latest initiative is the PL/SQL Challenge (http://www.plsqlchallenge.com), a daily quiz for PL/SQL developers; hundreds of programmers play each day. Check it out and join the fun! 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 http://feuerthoughts.blogspot.com.
Oracle PL/SQL Programming: Guide to Oracle8i Featu
May 17 2013My good friend, Marcelle Kratochvil, is the Oracle ACE Director for (as she put it to me) "all data/any data." She's been working with Oracle since V4 and specializes in Oracle Multimedia. She has been a beta tester for this product since Oracle8i and runs… read more
May 13 2013My good friend, Marcelle Kratochvil, is the Oracle ACE Director for (as she put it to me) "all data/any data." She's been working with Oracle since V4 and specializes in Oracle Multimedia. She has been a beta tester for this product since Oracle8i and runs a SIG on multimedia and… read more
May 13 2013Problem: Jasper queries the same, unchanging data over and over and over again. Like most applications, the My Flimsy Excuse application (www.myflimsyexcuse.com) contains lots of tables. Most of them contain data that is constantly changing. New customers are added almost every minute. Excuses are created, used by customers, edited, and… read more
May 08 2013Back in mid-March, I wrote:A week ago, I played a game of Scabble with Veva and scored 32 points by placing the word "SEEN" on the board. Now, every letter in "SEEN" is worth 1 point, making it very difficult to get to 32 points. But I attached "SEEN" to… read more
May 08 2013Haven't shaved for two weeks. Decided to give my skin a break, and I also wondered: what do I really look like? Shaving my head is, I have come to accept, the "main vain" thing I do in my life (well, that and painting flamboyan flowers on my toenails).How much… read more
May 08 2013Back in April 2010, I started up the PL/SQL Challenge (www.plsqlchallenge.com) to provide quizzes on PL/SQL, SQL, logic and Oracle Application Express.Hundreds of people take these quizzes each day. Since that time, over 670,000 answers have been submitted by thousands of Oracle technologists.But you can't please everyone. I received this… read more
April 17 2013Steven discusses why your subprograms should be defined inside a package with overloading of that subprogram (a procedure or function with the same name, but with the new parameter list that contains the OUT or IN OUT argument) added to support different requirements.Tags: oracle,plsql,package,function,overloading,argument,parametersCategory: PL/SQL Obsession read more
April 12 2013A recording of a recent Toad DB2 Tips and Tricks is now availableCategory: Toad for IBM DB2 read more
April 10 2013I get this very question at least once a month – sometimes more. The problem report is always exactly the same – “The Toad debugger toolbar icon is disabled (greyed-out) and so I cannot debug my code!” Of course since Toad won’t let them do what they want, it is… read more
April 09 2013People have questions regarding Toad for Oracle in relation to Oracle licensing requirements. They want to know “Does Toad for Oracle require purchasing optional, additional cost Oracle price book items. In short, Toad for Oracle does not require buying anything other than the Oracle database. However questions persist. Here are the… read more
April 09 2013Ever wanted to perform some operation against all the objects in a schema? For example a one-time management task to turn off parallel for all tables and indexes. Another example might be an on-going task to disable and later enable triggers and referential integrity to speed up a recurring data… read more
April 08 2013Here is a report that uses pivot grids.Tags: toad data point,pivot grid,reports,automation,excel,template,script,automation designerCategory: Toad Data Point read more
April 01 2013I do a lot of database benchmarking, and have been doing so for well over a decade. As such I’m often engaged in pre-sales, post-sales and tech support calls and/or live web sessions helping prospects and customers using Benchmark Factory to run industry standard database benchmarks (e.g. TPC-C) and/or perform… read more
April 01 2013Single result sets exported to Excel may not be enough for your needs. You might have a project where the end user wants multiple results in a single page. And of course you would like to make it attractive.Tags: toad data point,automation,excel,export,reports,script,templateCategory: Toad Data Point read more
March 29 2013In my recent blog titled “Copying Database Data to Microsoft Excel via Toad” I showed how easily Toad can export data into Excel – a favorite tool of many business analysts. But what if instead the data starts out in Excel and I want to get it loaded into Oracle?… read more
March 28 2013Many business analysts rely heavily upon Microsoft Excel as one of their primary tools for manipulating and reporting upon their business data. Common ways they often get access to the database data include: Sending database data extraction requests to their information systems (IS) people to perform and then deliver the… read more
March 27 2013Find out how to use Toad Data Modeler’s Gallery and how to add equally named columns to all tables in your entity relationship diagram.
Hire Steven Feuerstein
For Inquiries Contact
Find Other Authors
Buy Now and Save
Use discount code: OPC10
All orders over $29.95 qualify for free shipping within the US. See details.
"If you are responsible for PL/SQL coding, this book needs to be on your desk. Period. "
--Michael Wehrle, Amazon.com