05Oct
By: Steven Feuerstein On: October 5, 2022 In: APEX Developer Solutions, Feuertips Comments: 0

SQL makes adding rows to a table easy. Just execute an insert statement! But there are several nuances to consider. Steven goes over them.

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

Steven and special guest Anton Nielsen talk about their favorite goodies in the #orclapex PL/SQL API. Much heavy lifting by APEX!

Read more
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
15Jun
By: Marc Ruel On: June 15, 2022 In: Feuertips Comments: 0

Taking a break from presenting a tip on a specific topic, Steven and co-host Michelle Skamene walk through a recent refactoring he did with an Insum consultant.

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