Get working days between two working date excluding weekends
This function which will help you to get number of working days between two date excluding the weekends. This will help other to get logic between two working date.This is…
Read Moreoracle unpivot function
The Oracle UNPIVOT clause allows you to transpose columns to rows. The UNPIVOT clause is opposite to the PIVOT clause except that it does not de-aggregate data during the transposing process. It’s Very helpful when you…
Read MoreUtilities-Recycle Bin In Apex,Restore dropping Objects
As You know that The role of Recycle Bin ,in Apex, Recycle bin also works in similar way. From a developer prospective it is really helpful to get back the…
Read MoreApex String Split with APEX_STRING.SPLIT
This is very helpful. optimizing-member-of-with-apex_string.split_ is a great utility that allows you to take a delimited list and make it query able. By help of this you can split comma…
Read MoreApex find Error, Session Monitor, Performance Monitor and Trace
In this, Developer can monitor the performance of the Application, session and other Apex page issue error. This is very helpful from developer side . to-find-the-error-in-apex-and-sessiontrace-in-apex
Read MoreTo Find IP Address of the User who login into Apex Application
This query will help to sql, Plsql and Apex Developer to find the user IP Address. Normally we tracking only page id, username and time of the user for login…
Read MoreInteractive Grids button’s customization
Attachment : interactive-grids-button-customization This document will help you to change the IG Buttons name and logo code- function(config) { let $ = apex.jQuery, toolbarData = $.apex.interactiveGrid.copyDefaultToolbar(), addrowAction = toolbarData.toolbarFind(“selection-add-row”),…
Read MoreFind Missing Page numbers in oracle Apex Application
Attachment: find-missing-page-numbers-in-oracle-apex-application This code will help You to find the missing page number. Suppose we deleted some page between 1 to 900. Then we can now what are the page…
Read MoreFind The details about apex workspace ip, port and other client details
Attachment: apex-workspace-ip-port-and-other-client-details This is very helpful plsql code , which will give you details of your workspace, ip, port and client details. It will help when any application level…
Read More