Feuertip #26: Help save our planet with the result cache
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
On the subject of auditing tables, Anton presents Flashback Data Archive with special guest and fellow Insumnian Richard Soule.
Read more
Today's tip is focused on improving the readability of your code using APEX_STRING.FORMAT during a code review.
Read more
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
Hayden and Anton's special guest Plamen Mushkov shows how to secure a REST API he built using just APEX and ORDS.
Read more
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
Oracle SQL developer can quickly provide you with full table auditing, within just a few clicks. Hayden's colleague David Schleis demonstrates.
Read more
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
In this APEX Instant Tip, Hayden introduces Anton and the audience to the apex_debug JavaScript API. He then shows Anton the advantages of using it instead of console.log in APEX.
Read more
Steven explores how to select not from a table or a view but a function. More specifically, from a table function.
Read more
Recent Comments