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
22Dec
By: Marc Ruel On: December 22, 2021 In: Feuertips Comments: 0

The AUTHID clause at the top of a package talks about "invoker rights" and "definer rights". Steven explains in this final episode of 2021.

Read more
08Dec
By: Steven Feuerstein On: December 8, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

In this episode learn how to take advantage of the PL/SQL compiler's ability to suggest improvements by turning on compile-time warnings.

Read more
24Nov
By: Marc Ruel On: November 24, 2021 In: APEX Developer Solutions, Feuertips, Insum Life Comments: 0

Steven uses the day before Thanksgiving to look back on his 30 years with PL/SQL and share some of the things he is most thankful for.

Read more
09Nov
By: Steven Feuerstein On: November 9, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

In this episode of Feuertips, Steven invites Chris Saxon back to #Feuertips to talk about polymorphic table functions.

Read more