In this blog I will be explaining how to convert Numbers to Roman Numerals using a SQL query. Existing Report:  I have an Interactive Report where I  have four columns (ID, Name, Salary and Rank). I am displaying the rank of the employees that is ordered by the salary in descending order.  Requirement: My requirement is to display the rank in roman numbers.  How can this be achieved using a simple SQL query? Follow the below steps to achieve this. Let me explain this with an example: 1) Create a table create table t_employee( emp_id number, emp_name va ..read more

In this blog I will be explaining, how to show a Button with Spinner/Progress Indicator in Oracle APEX. In Oracle APEX, by default the spinner will be displayed on the page but in one of my requirements I had to display the spinner in a button instead of displaying it in the page. So I followed the below steps to achieve it. 1) Create a Region in the page, 2) Create a Button in the region. (In this example: P37_PROGRESS_BUTTON) 3) Add the class custom-button-spinner in the Appearance -> CSS Classes section of the button.  4) Add the below code in the Execute When Page Loads ..read more

 In this blog I will be explaining, how to get the details of a file(s), selected using a File Browse Item, using JavaScript in Oracle APEX. For Single File: 1) Create a Region. 2) Create an Item (Type: File Browse) in the Region. (In this example: P1_FILE_BROWSE). 3) Create 3 More items in the page to store the File Name, File Size and File Type.                  (In this example: P1_FILE_NAME, P1_FILE_SIZE, P1_FILE_TYPE)  4) Create an On Change Dynamic Action on the P1_FILE_BROWSE item. 5) Create a True Action (Type: Execute J ..read more

In this blog I will be explaining how to restrict users from typing only numbers/decimal values in a Number/Text Item in Oracle APEX. 1) Create a Region.    2) Create an Item in the page (Type: Text Field or Number Field). 3) To allow only Numbers, paste the below code in the Page -> Execute When Page Loads Section. $("#P30_NUMBER_FIELD_ITEM").keypress(function(event){ event = (event) ? event : window.event; var charCode = (event.which) ? event.which : event.keyCode; if (charCode > 31 && (charCode < 48 || charCode > 57)) { return false ..read more

This blog explains how to highlight the Interactive Grid cells using JavaScript instead of using the inbuilt highlight feature. Let us start with a one-line information about Mutation Observer:  The Mutation Observer provides the ability to watch for changes made in the DOM tree. What advantage does the Mutation Observer have when compared to the normal way of highlighting. Let me tell this with an example.    Customer: I want an Editable  Interactive Grid that highlights the status field on Page Load and when the changes are made and saved. The color must also remain wh ..read more

  This blog explains, how to Show Help Text using JavaScript in Oracle APEX.  Follow the below steps to achieve this. 1) Create a Region.  2) Create a Button in the region. 3) Create an On Click dynamic action for the button. 4) Create a True Action (Execute JavaScript Code) and paste the below code. apex.theme.popupFieldHelp({     title: "Help",     helpText: 'This is a help text box' }); The Help Text also accepts HTML. Below is an example on how to use HTML in the help text. apex.theme.pop ..read more

This blog explains, how to change the column width of and Interactive Grid using JavaScript. Follow the below steps to achieve this: Example - 1: Set the Column Width for a single Column. 1) Put the below JavaScript Code in the Page -> JavaScript -> Execute When Page Loads section. apex.region("EMP_IG").call("getViews").grid.view$.grid("setColumnWidth","EMPLOYEE_NAME",200); Note:  In the above code, the width of the Employee Name column is set to 200.  Replace EMPLOYEE_NAME with the name of your column that you want to set the width for. Replace EMP_IG with the Static ..read more

In this post we will see, Different ways to hide save button using JavaScript/CSS in Oracle APEX Interactive Grid. Method 1:  Using any one of the below JavaScript code in the Execute When Page Loads section of the page. apex.region("YOUR_IG_STATIC_ID").call("getActions").hide("save"); (OR) $("#YOUR_IG_STATIC_ID .a-Button.a-Toolbar-item.js-actionButton.a-Button--hot[data-action='save']").hide(); Method 2:  Using the below JavaScript code in the JavaScript Initialization Code section in the Interactive Grid. function (config) {    ..read more

This blog explains how to disable update for a particular column in Interactive Grid using the Read Only property of a column.  Should we use JavaScript to achieve this? The answer is, NO!!!  Follow the below steps to achieve this 1) Create an Interactive Grid 2) Select the column that has to be made read only when trying to update.  In this example, the ROLE Column has is made read only when trying to update 3) Scroll down to the Read Only property of the column and do the changes as shown in the below screenshot. Note: It is not mandatory to ..read more

In this blog I will be explaining, how to display an Inline Popup as a callout. Follow the below steps to achieve this: 1) Create a Region  2) Create a Button in the region, provide a static ID to the button (Advanced -> Static ID)         3) Create another Region  and select the below properties for the region. Layout -> Position -> Inline Dialogs (Optional) Appearance -> Template -> Inline Popup 4) Click on the Template Options (Appearance -> Template Options) of the region. The below mentioned points are mandatory:  Check t ..read more