Social Sign-in has been around since APEX version 18. And with small differences, the main concepts regarding Single Sign On in APEX using Facebook, Google, Microsoft, OKTA or any other 3rd party authentication provider have been the same. There are numerous blog post I have read and videos watched during the time. If your setup … Continue reading OKTA authentication for APEX in 5 minutes
Redwood theme I am a big fan of Redwood theme from the first minute it was released for the APEX Builder. Luckily for us, the developers and users, it can be now used as an application theme too. The new version of APEX (21.1) even gives the ability to modify it (a little) through the … Continue reading Redwood theme backgrounds revealed
Adding favicon for your application Create a PNG image - with dimensions 256x256 pixels. You can use Photoshop or any other editing software. Go to https://realfavicongenerator.net/ and generate an .ico file. Alternatively, use a tool of your preference and generate .ico files both 32x32 and 16x16 pixels. Download the .zip archive generated to your local … Continue reading Quick Tips: Add favicon and custom Application icon in APEX
Introduction & helpful links In the following blog post I will try to explain the options you have to modify your APEX JET powered charts. There are different ways to change certain parts of them, some are easier and straight forward, others require more complex approach and writing some Javascript and CSS. In the first … Continue reading Taking your APEX JET charts style to the next level
Present and future of Markdown in APEX In the production version of APEX (20.2), you could benefit of the Markdown language being integrated into different parts of it. I won't go into details how cool is Markdown, what it is and what are the various places you could use it. I will just mention that … Continue reading APEX & Markdown – the story continues
Switching your application theme is getting more and more popular in recent years. APEX apps and their users are no exception. Most of our devices support this feature, APEX itself introduced dark and light mode for the Application Builder too. I am going to show you a quick way of integrating it into your application. … Continue reading Auto switch Dark & Light modes of your APEX app
One of the most popular places to store and share your code online is GitLab. And one of the best free desktop Version control tools is without any doubt Sourcetree. Here is a quick overview of how to link them without losing any precious time and energy. So here is my setup: A GitLab account.A … Continue reading Link Sourcetree to your GitLab account
One of the most popular places to store and share your code online is GitHub. And one of the best free desktop Version control tools is without any doubt Sourcetree. Having all the good feature, of using them both, in mind, there are still some moments that can ruin your experience, especially when you are … Continue reading Link Sourcetree to your GitHub account
It happens that you forget your master ADMIN password for the apex_admin page. Here are the two widely user methods to change it and unlock the Admin account: Use @apxchpwd.sql script in your APEX directory. To run it, navigate to the directory through bash or Command prompt. Connect to your database as SYS and run … Continue reading Unlock APEX Admin account
It happens relatively rarely to have an error PLS-00907 (PLS-00907: Can not load library unit). We have encountered it few times in our APEX applications. Here is the way to resolve it (performed by a SYS user). Solution : Ask your DB admin to flush the shared pool 🙂
APEX App Lab - Blog 