http://twitter.com/stevefeuerstein
Chicago, Illinois
Oracle PL/SQL expert, evangelist, author and trainer
Areas of Expertise:
- PL/SQL
- Oracle
- stored procedures
- consulting
- speaking
- training
- writing
Steven blogs at:
http://feuerthoughts.blogspot.com
http://www.toadworld.com/sf
Win a Copy of the New Oracle Multimedia Book!
May 17 2013
My 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 moreWin a Copy of the New Oracle Multimedia Book!
May 13 2013
My 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 moreMay 13 2013
Problem: 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 moreHow to Get 32 Scrabble Points with SEEN
May 08 2013
Back 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 moreWhat I Look Like When Shaving Stops
May 08 2013
Haven'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 moreCan't please everyone, I suppose
May 08 2013
Back 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 moreApril 17 2013
Steven 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 moreApril 12 2013
A recording of a recent Toad DB2 Tips and Tricks is now availableCategory: Toad for IBM DB2 read moreHelp – Toad for Oracle PL/SQL Debugger Not Working
April 10 2013
I 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 moreToad and Oracle Licensing – What’s the Story?
April 09 2013
People 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 moreOracle Dynamic Scripting – SQL Script to Create & Run a SQL Script
April 09 2013
Ever 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 moreToad Data Point Automation Series: #4 – Excel Pivot Grids
April 08 2013
Here is a report that uses pivot grids.Tags: toad data point,pivot grid,reports,automation,excel,template,script,automation designerCategory: Toad Data Point read moreBenchmarking – Reality vs. Perception
April 01 2013
I 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 moreToad Data Point Automation Series: #3 – Complex Reports
April 01 2013
Single 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 moreCreate and Load Oracle Tables from Excel Spreadsheet using Toad
March 29 2013
In 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 moreCopying Database Data to Microsoft Excel via Toad
March 28 2013
Many 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 moreHow to add predefined columns to all tables
March 27 2013
Find out how to use Toad Data Modeler’s Gallery and how to add equally named columns to all tables in your entity relationship diagram.Also find Steven on:
Recent Twitter posts:
Buy Now and Save
Buy 2 books, get the 3rd FREE
Use discount code: OPC10
All orders over $29.95 qualify for free shipping within the US. See details.
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. "
--
