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
26Jan
By: Steven Feuerstein On: January 26, 2022 In: APEX Developer Solutions, Feuertips Comments: 0

Learn how to generate a conditional compilation package so that your code uses the latest features in APEX APIs - and your own products!

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

Toon Koppelaars of Oracle's Real World Performance Team discusses the ORA-04068 error with Steven, and what to do if you get it.

Read more
14Jan
By: Steven Feuerstein On: January 14, 2022 In: APEX Developer Solutions, Feuertips Comments: 1

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

Read more