Anton and special guest Plamen Mushkov discuss the advantages of SYS_CONTEXT and how to utilize a context within the scope of an APEX Application. Unfortunately, they neglected to comment on how handy it can be when creating views, but maybe that will be a follow-up episode.
Also included: A tip from Plamen on some hidden browser tools.
View Past Episodes
Full episode list on YouTube here.
APEX Instant Tips #113: How to merge data during application deployement
Hayden describes how one can merge from the zipped static file that Data Packager creates for...Read more
APEX Instant Tips #112: Always filter APEX views by workspace_ID
Filtering APEX views by workspace_ID has the advantage of making your results more intuitive as well...Read more
APEX Instant Tips #111: How to masquerade as another user
Anton and Hayden demonstrate how to test authorization schemes effectively by masquerading as another user.Read more
APEX Instant Tips #109: Writing Fast Queries Part 1
An overview of several tips from Anton's blog post about writing fast queries and a demo...Read more
APEX Instant Tips #108: Basic Liquibase
Built into SQLcl for everyone to use is Liquibase. Hayden demonstrates his preferred method for its...Read more
APEX Instant Tips #107: APEX Session Overrides
Session overrides is an APEX feature that enables you to code in local files that affect...Read more
APEX Instant Tips #106: A few pointers on SQLcl
Using their 5 minutes to its max (and then some), Hayden and Anton discuss Formatting and...Read more