When building a Progressive Web Application (PWA) in Oracle Application Express (APEX), there are several orientation settings that you can configure to control how the application is displayed on a mobile device. APEX – PWA screen orientation settings determine the default orientation and supported orientations for the PWA. You can edit PWA Screen Orientation setting …

A blog after many years, thanks to @Jaydip Bosamiya for encouraging me to resume blogging. Recently one of our client wanted to implement Office 365 email integration within Oracle APEX application. First we started PoC by reviewing Microsoft Graph API, we downloaded Postman Collection, found useful parameters to Sort, Filter and Select columns within Microsoft …

A blog after many years 🙂 My best practices for PL/SQL are below: Always use Exception Block within each block, function, procedure Send email to your development team for any error which occurs in Production Give top priority to error email Make sure you will never get any error email 🙂 Write reusable procedures/functions and …

It is quite possible you could work with Oracle databases for many years and never come across the ALL, ANY and SOME comparison conditions in SQL because there are alternatives to them that are used more regularly. You can find more info on Oracle-Base Article. I hope this will be quite useful to many developers. …

Hi friends, How to calculate difference between columns of current and previous/next row? Let’s say, you want to monitor how often products are sold from your store. i.e.  You want difference between current and previous SELL_DATE then you can write query as follows: SELECT TO_CHAR(SELL_DATE, ‘DD-MON-YYYY HH24:MI:SS’), TO_CHAR(LAG(SELL_DATE) OVER (ORDER BY SELL_DATE), ‘DD-MON-YYYY HH24:MI:SS’) AS …