21Sep
By: Steven Feuerstein On: September 21, 2022 In: APEX Developer Solutions, Feuertips Comments: 0

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

Read more
20Jul
By: Steven Feuerstein On: July 20, 2022 In: APEX Developer Solutions, Feuertips Comments: 0

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

Read more
By: Steven Feuerstein On: July 13, 2022 In: Uncategorised Comments: 2

Sam Nitsche recently interviewed me for an article in the DOAG (German Oracle User Group) RedStack magazine. That was fun! You can find the entire article in English on Sam’s blog. I especially love the title Sam used for his post: Stop Hiding From Your Planet In any case,...

Read more
01Jun
By: Steven Feuerstein On: June 1, 2022 In: APEX Developer Solutions, Feuertips Comments: 0

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

Read more
18May
By: Steven Feuerstein On: May 18, 2022 In: APEX Developer Solutions, Feuertips Comments: 0

An episode all about triggers. They can be amazing, but they can be abused and lead to unexpected behaviors. Steven drills down.

Read more
27Apr
By: Steven Feuerstein On: April 27, 2022 In: APEX Developer Solutions, Feuertips Comments: 0

When should you commit changes in your PL/SQL code? When does PL/SQL itself perform commits for you on your behalf? Find out in this episode of Feuertips.

Read more
13Apr
By: Steven Feuerstein On: April 13, 2022 In: APEX Developer Solutions, Feuertips Comments: 0

Cursor for loop is an example of #plsql's tight integration with #SQL, but it also presents opportunities for "bad lazy" coding. Steven explains

Read more
01Apr
By: Steven Feuerstein On: April 1, 2022 In: APEX Developer Solutions, Feuertips Comments: 0

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

Read more
18Mar
By: Steven Feuerstein On: March 18, 2022 In: Feuertips Comments: 0

Following up on the previous Feuertip on dynamic SQL, Steven is joined by Anton Nielsen to explore how to use dbms_assert to reduce the chance of SQL injection and otherwise bullet-proof your code.

Read more
By: Steven Feuerstein On: March 17, 2022 In: Uncategorised Comments: 0