Profile cover photo
Profile photo
Steven Feuerstein
530 followers
530 followers
About
Steven's posts

Post has attachment
Nine Good-to-Knows about PL/SQL Error Management
1. Exceptions raised in the declaration section are not handled in the exception section. This sometimes surprises a developer new to PL/SQL. The exception section of a PL/SQL block can only possibly handle an exception raised in the executable section. An ...

Post has attachment
A Checklist for Bulk Processing Conversions in PL/SQL
[ Note: download the latest version of the checklist from OTN . You can comment on the checklist there, or on this blog post. Thanks!] Bulk processing (FORALL and BULK COLLECT) is pretty much the most powerful and important performance feature available for...

Post has attachment
I Love Backups and APIs, a.k.a., Test Delete Processes VERY THOROUGHLY
The PL/SQL Challenge offers weekly quizzes on SQL, PL/SQL, Database Design, Application Express, and Logic. A week on this website starts on Saturday at 00:00:00
 UTC and ends on Friday at 23:59:59 UTC. So early in the morning on Saturday, we run weekly pro...

Post has attachment
Use TABLE Operator with Associative Arrays in Oracle Database 12c
Starting with 12.1, you can now use the TABLE operator with associative arrays whose types are defined in a package specification. One really sweet application of this feature is to order the contents of your collection. Let's take a look Suppose I create t...

Post has attachment
PL/SQL Challenge approaches 1,000,000 answers....how should we celebrate?
Chris Saxon , the PL/SQL Challenge Database Design Quizmaster and Oracle Database Advocate for SQL and member of Ask Tom Answer Team, reminded me yesterday that the number of answers submitted on the PL/SQL Challenge is getting close to 1M. Now in the, ahem...

Post has attachment
Getting started (and "playing around") with PL/SQL (and SQL (and Oracle Database))
Got this email Monday from a fellow new to PL/SQL and Oracle: I have been in I.T. for a couple of years but always had this feeling that I could do better. I lost that hunger when the company I had worked for 10 years plucked me from the warehouse as a kind...

Post has attachment
TwitterQuiz results: What could be safely deleted from this code?
Last week, I posted this on Twitter : What code can be removed w/o changing text shown after execution? Who Said What? evrocs_nl putting data in collection before the select, because the bulk collect will clear the collection first (unless really old oracle...

Post has attachment
My Oracle Database Advocate resolutions for 2016
Oracle Database Insider newsletter asked me to do another round of resolutions for the coming year. Since I love it when other people act as though they are interested in what I have to say, I told my manager I would have to clear my calendar for a couple o...

Post has attachment
PL/SQL Brain Teaser: Find all the hard-codings!
We all know that hard-coding is a bad thing (well, maybe not all of us . At one training several years past, I asked the audience "Does anyone think hard-coding is a good idea?" and one person raised his hand. Um, OK). You know hard-coding: when you say to ...

Post has attachment
LOG ERRORS: Suppress row-level errors in DML (from PL/SQL Challenge)
Last week, several hundred players tested their knowledge of the LOG ERRORS feature, and associated with it, the DBMS_ERRLOG package. Check out the quiz here , but feel free to explore the topic below! Use LOG ERRORS to suppress row-level errors from within...
Wait while more posts are being loaded