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
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
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
21Oct
By: Steven Feuerstein On: October 21, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

Samuel Nitsche joins Steven for a lively conversation about the obstacles we face when testing our PL/SQL code.

Read more
11Oct
By: Steven Feuerstein On: October 11, 2021 In: APEX Developer Solutions Comments: 0

Introducing APEXd2d, a unique real-time problem-solving clinic, created for APEX developers by APEX developers.

Read more
06Oct
By: Steven Feuerstein On: October 6, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

Carelessly using the result cache can result in the delivery of dirty data. In this episode, Steven shows us how to avoid that.

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

The result cache is an Oracle Database feature that helps avoid unnecessary CPU consumption. Use it and help save the planet in the process!

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

Did you know you can execute dynamic PL/SQL? In this Feuertip, Steven offers some tips on writing and running dynamic PL/SQL blocks.

Read more
01Sep
By: Steven Feuerstein On: September 1, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

Continuing Steven's series on table functions, Chris Saxon of Oracle AskTOM fame drops by to talk about a fantastic, new Oracle Database feature: SQL macros.

Read more
25Aug
By: Steven Feuerstein On: August 25, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

Table functions are wonderful but "typical" tools. In this episode Steven explore a special, strange and delightful version of table functions, called pipelined table functions.

Read more