Table Alter Script by comparing 2 schema
Table of Contents Overview Technologies and Tools Used Use Case Architecture Screen Shot 1. Overview This document will be helpful to compares Prod and Dev schema and generates alter scripts…
Read MoreHow to set the interactive grid column values to the page item
Overview This document talks about how set the interactive grid column values to the page item.this is achieved using JavaScript. Technologies and Tools Used The following technologies has been used to achieve the expected output. JavaScript Use Case Assume that we are having the interactive grid report. We want to do some operation based on the values on the interactive grid column then,we can use this method to achieve the same. This document explains how to achieve this requirement. Architecture Following steps explains in detail, Step 1: We needs to add the static ID to the interactive grid region. Step 2: We needs to create dynamic action on the Lose Focus event ,selection type as region and region as the which region you want to take the column values. True action of the dynamic action is execute JavaScript.we needs to add the below JavaScript to execute JavaScript region . var data=””; var model = apex.region(“IG_REGION”).widget().interactiveGrid(“getViews”, “grid”).model; model.forEach(function(igrow) { //ENAME will be column name which you want to get values var test =igrow[model.getFieldKey(“ENAME”)]; //For some version above will not work for that use the below code // var test =igrow[model.getFieldKey(“ENAME”)].d; //here d is display value ,even we can use return value r also.…
Read MoreSteps to Uninstall Apex in Database
Please follow the below steps col COMP_ID for a15 col COMP_NAME for a45 col STATUS for a20 set lines 100 pages 100 select COMP_ID,COMP_NAME,STATUS from dba_registry; COMP_ID COMP_NAME STATUS —————…
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 MoreProtect Row Update & Delete in IG
1. Overview This document will be helpful in protecting updation on a row based condition in Oracle apex interactive Grid. 2. Technologies and Tools Used Oracle Apex code. 3. Use Case In…
Read MoreHow to remove the interactive grid default alert for unsaved changes
Overview This document talks about how to remove the interactive grid default alert for unsaved changes.we are going to achieve this requirement using JavaScript. Technologies and Tools Used The following technologies has been used to achieve the expected output. JavaScript Use Case Assume that we are having form region and interactive grid region on the same page.We are having the same save button for the both region.In this scenario ,If we write the on change event for refresh of the interactive grid region. This will throw error for unsaved changes and the selected values in the form region will get clear. To over come this we are going for the JavaScript. This document explains how to achieve this requirement. Architecture Following steps explains in detail, Step 1: We needs to add the static ID to the interactive grid region. Step 2: In the change event of the button or item, we have to add the dynamic action to execute JavaScript and we needs to add the below code. apex.region(‘IG_REGION’).widget().interactiveGrid(‘getViews’, ‘grid’).model.clearChanges(); apex.region(“IG_REGION”).refresh(); Screen Shot Output: Using the above step we can remove the unsaved changes alert of the interactive grid.
Read MoreAdding Customized Background Color to the Interactive Report Cell
Overview In this document, we are going to see about how to add customized background color in report cell of interactive Report.This is achieved using CSS and JavaScript.Also,Different method to…
Read MoreConverting rows to columns using Oracle Pivot clause
The Oracle introduced the PIVOT clause from oracle 11g. This makes converting rows to column easy. The value in the new columns must be the result of an aggregate function…
Read MoreCaps Lock (On/Off) Indicator with JavaScript in Oracle APEX
Overview This document talks about how to indicate a message for whether the Caps Lock is on or off while inserting a password in login page by using JavaScript in…
Read MoreTechnical Solutions For Single Search box Filter the Value with highlights in Multiple Reports
Overview This document explains how to search single search box in Multiple reports with highlights using Oracle Apex Technologies and Tools Used The following technologies has been used to achieve…
Read More