05May
By: Marc Ruel On: May 5, 2023 In: Instant Tips Comments: 0

An overview of several tips from Anton's blog post about writing fast queries and a demo showing some queries don't need to read the table.

Read more
02May
By: Marc Ruel On: May 2, 2023 In: Instant Tips Comments: 0

Built into SQLcl for everyone to use is Liquibase. Hayden demonstrates his preferred method for its deployment.

Read more
21Apr
By: Marc Ruel On: April 21, 2023 In: Instant Tips Comments: 0

Session overrides is an APEX feature that enables you to code in local files that affect only your APEX session. Hayden and Anton discuss.

Read more
14Apr
By: Marc Ruel On: April 14, 2023 In: Instant Tips Comments: 0

Using their 5 minutes to its max (and then some), Hayden and Anton discuss Formatting and Aliasing in SQLcl.

Read more
31Mar
By: Marc Ruel On: March 31, 2023 In: Instant Tips, Uncategorised Comments: 0

In this episode, how to get search engines interested in your APEX pages despite their distaste for things like parameters in the URL.

Read more
24Mar
By: Marc Ruel On: March 24, 2023 In: Instant Tips Comments: 0

Hayden and Anton explore methods for hiding and showing columns including serverside condition, dynamic action "hide" vs "show" and more.

Read more
17Mar
By: Marc Ruel On: March 17, 2023 In: Instant Tips Comments: 0

in 5 minutes, Anton and Hayden take us through 3 useful tips 1. How to shorten your long strings but still leave them searchable 2. Tokenize your search 3. Change date format with computed column

Read more
10Mar
By: Marc Ruel On: March 10, 2023 In: Instant Tips Comments: 0

Anton and Hayden take you as deep as they can go in 5 minutes on "Prevent Lost Updates," "Lock Row," and "ListAgg.

Read more
03Mar
By: Marc Ruel On: March 3, 2023 In: Instant Tips Comments: 0

In this episode, Anton and Hayden unpack 3 gripes they have about APEX and include some useful workarounds...

Read more
24Feb
By: Marc Ruel On: February 24, 2023 In: Instant Tips Comments: 0

Hayden and Anton have held onto this "extra sketchy" tip for quite a while. It's worthy of APEX Instant Tips episode 100. We can't really recommend it--but we do it all the time. You be the judge.

Read more