Feuertips with Steven Feuerstein

Curious about the problems you can solve with the APEX_STRING PL/SQL utility? Steven receives special guest...

Steven invites long-time Oracle developer Morten Braten to do a live code review of some possibly...

who do you think understands PL/SQL code better? Steven or ChatGPT? See GPT's recommendations for...

Steven talks about refactoring code to avoid duplication. Michelle Skamene also joins to show her meal-planning...

Two high-performance paths to inserting multiple rows with a minimum number of context switches. Which...

Oracle Database has dates, timestamps, timestamps with timezones. special guest host Anton Nielsen sorts this out...

SQL makes adding rows to a table easy. Just execute an insert statement! But there are...

Steven and special guest Anton Nielsen talk about their favorite goodies in the #orclapex PL/SQL API....

Steven's special guest Monika Lewandowska provides tips to organize PL/SQL code to make it deterministic while...

In this week' Feuertip, Steven explores PL/SQL parameters and uncovers some interesting aspects you might not...

Taking a break from presenting a tip on a specific topic, Steven and co-host Michelle Skamene...

Steven dives into deterministic functions. What they are, why you'd use them, and how they're different...

An episode all about triggers. They can be amazing, but they can be abused and lead...

When should you commit changes in your PL/SQL code? When does PL/SQL itself perform commits for...

Cursor for loop is an example of #plsql's tight integration with #SQL, but it also presents...

Steven shares some tips on how to write declarations in PL/SQL subprograms or packages for maximum...

Following up on the previous Feuertip on dynamic SQL, Steven is joined by Anton Nielsen to...

Don't have all the info you need at compile time to write a complete SQL statement?...

In this episode Steven looks back over several of his previous tips. Plus, a recent obsession:...

Learn how to generate a conditional compilation package so that your code uses the latest features...

Toon Koppelaars of Oracle's Real World Performance Team discusses the ORA-04068 error with Steven, and what...

Steven introduces invoker rights (AUTHID). Learn some essential differences between definer rights and invoker rights in...

In this episode learn how to take advantage of the PL/SQL compiler's ability to suggest improvements...

Steven uses the day before Thanksgiving to look back on his 30 years with PL/SQL and...

In this episode of Feuertips, Steven invites Chris Saxon back to #Feuertips to talk about polymorphic...

Samuel Nitsche joins Steven for a lively conversation about the obstacles we face when testing our...

Carelessly using the result cache can result in the delivery of dirty data. In this episode,...

The result cache is an Oracle Database feature that helps avoid unnecessary CPU consumption. Use it...

Did you know you can execute dynamic PL/SQL? In this Feuertip, Steven offers some tips on...

Continuing Steven's series on table functions, Chris Saxon of Oracle AskTOM fame drops by to talk...

Table functions are wonderful but "typical" tools. In this episode Steven explore a special, strange and...

Steven explores how to select not from a table or a view but a function. More...

The returning into clause is one of the best examples of the tight integration between SQL...

Steven dives into the PL/SQL function sqlerrm in this week's episode of Feuertips

In this episode of Feuertips, Steven talks about one very special and unusual PL/SQL package, called...

When invoking procedures and functions, you can specify arguments for parameters in two different ways: positional...

#sqlcode returns the current error code. Ah, but that simple functionality can hide so many interesting...

In this episode, Steven dives into the challenge of handling exceptions that occur when you run...

Collections are PL/SQL's version of arrays. Steven talks about ways you can, should, shouldn't iterate...

In this blog, Steven proposes a refactoring exercise. Look at the code. What changes does it...

In this blog for episode 12 of Feuertips, Steve shows us how to suppress row-level...

Naming conventions are key to writing high-quality code. Steven explores what motivates conventions to clarify what...

In this episode: to manipulate in-program data in set-kinda ways, use nested tables. They have cool,...

The WITH keyword lets us use modular design with SQL and helps avoid redundant logic in...

If you can't always perform automated regression testing, you can build a simple test harness and,...

The execution of non-query DML can cause all sorts of SQL errors. Steven lays out guidelines...

What should be in your exception handling section? Things pertaining to exception handling. What shouldn't?...

A developer takes out "insurance" when they write code to "make sure" or "just in case"....