07Apr
By: Steven Feuerstein On: April 7, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

PL/SQL packages are great! But there is one package feature you shouldn’t use: Initialization. Your first inclination should be to avoid it. Steven Feuerstein explains why.

Read more
24Mar
By: Steven Feuerstein On: March 24, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

Steven discusses when it makes sense to choose a string-indexed associative array (one of the three types of PL/SQL collections)

Read more
15Mar
By: Steven Feuerstein On: March 15, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

Lazy can be a good developer characteristic or a terrible one depending on how and when applied. Steven and Marlyn look at examples of each.

Read more
09Mar
By: Michelle Skamene On: March 9, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

Watch out for always using an IF statement, consider using a CASE expression, in SQL as well as PL/SQL, and then look for opportunities to use CASE statements as well.

Read more
X