02Aug
By: Steven Feuerstein On: August 2, 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
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
02Mar
By: Steven Feuerstein On: March 2, 2022 In: APEX Developer Solutions, Feuertips Comments: 0

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

Read more
09Feb
By: Marc Ruel On: February 9, 2022 In: Feuertips Comments: 0

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

Read more