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
18Aug
By: Steven Feuerstein On: August 18, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

Steven explores how to select not from a table or a view but a function. More specifically, from a table function.

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

The returning into clause is one of the best examples of the tight integration between SQL and PLSQL. Steven Feuerstein explains.

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

Steven dives into the PL/SQL function sqlerrm in this week's episode of Feuertips

Read more
29Jul
By: Steven Feuerstein On: July 29, 2021 In: APEX Developer Solutions, Feuertips Comments: 0
21Jul
By: Steven Feuerstein On: July 21, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

In this episode of Feuertips, Steven talks about one very special and unusual PL/SQL package, called STANDARD.

Read more
X