ORAPEX

Authentication is the first line of defense in any application, and in Oracle APEX , it plays a vital role in controlling how users access your system. While APEX provides several built-in authentication schemes, there are scenarios where the default options may not fully align with your business requirements. That’s when Custom Authentication becomes essential. In this blogpost, I’ll walk you through the step-by-step process of creating a Custom Authentication scheme in Oracle APEX —so you can design a secure, flexible, and application-specific login mechanism tailored exactly to your needs. If you need any visual assistance then you can follow  this tutorial . STEP- 1:  Create a database table (if not exist) to store application user information. In my case I use this table structure to store user information. You may add/drop column as per your requirements.      CREATE TABLE APP_USER           (      USER_SL N...

In modern application development, user experience and screen utilization play a critical role in productivity. Within Oracle APEX , maximizing the available screen real estate can significantly improve how users interact with complex dashboards, forms, and reports. Instead of being confined to default layouts, you can implement techniques to deliver a full-screen, immersive, and distraction-free interface . In this article, I will demonstrate professional approaches to maximize screens in Oracle APEX helping you design applications that are not only functional but also optimized for clarity, focus, and efficiency. For better understanding you can find a tutorial from  here . STEP- 1: Login to you application as a developer. Open shared components. Clik on the "Lists" under the "Navigation and Search" section. A new page will be opened showing existing navigation lists. Click on the report's row where showing the "Navigation Bar" under the "Nam...

In the first two part, we explored how to quickly add screens to our  Favorite List  for faster navigation. Now, in  last part , we’ll dive deeper and extend the functionality making it even smarter and more user-friendly. This continuation will help you maximize productivity while managing complex applications with thousands of menus. If you not explore the first two then please follow it first from  here (Part 1)  and  part 2 . You can follow below tutorials for better understanding.  Last Part ,  Part 2  and  Part 1 from here . Let's walk through the implementation process of last part step by step- Step- 1: Open your application builder home page. Click on shared component icon and then click on "Application process" link under the "Application Logic" section. From the application process list select the "SET_BOOKMARK" process. Click on the source tab or scroll below up to "Source > code". Modify the source code. Here, we wil...