Database Blog

Using Images as an Top Navigation Menu

Introduction           In Apex 5, Navigation Menu Position is either Side or Top Navigation. In the Side Navigation menu, if we apply the favicons, then it will display the menu…

Read More

Modal Dialog in Apex 4.2

Introduction              This post will help you to create a modal dialog page in Apex 4.2 with simple Javascript code. Scenario: A modal dialog has to open on button click…

Read More

Dynamically ordering of rows

Introduction           This post will help you to sort the rows in tabular form dynamically.   Steps to follow   Step 1: Create a tabular form with the query and…

Read More

File Type Validation using Java Script

Introduction File type validation before uploading to the server is mandatory for every file upload in the web application. It helps to ensure that the user has selected the correct…

Read More

Displaying of a select list and a button based on conditions in one Tabular Form Column

Introduction This post details the steps required to display a select list and a button based on condition in tabular form.   Problem statement  For already existing records in data…

Read More

Calculating Sum of 2 or More Fields in Oracle Apex

Introduction :  This post details the steps that required to calculate sum of 2 or more fields using function.  Steps to follow  Step 1: Create all the items which you…

Read More

Custom Popup page APEX 4.2

Introduction:  Although HTML DB allows application developers to declaratively add popup list of value (popup LOV) items to their pages, occasionally application design requires developers to create custom popup pages.…

Read More

APEX Reports with dynamic help text in Oracle APEX 4.2 using CSS

Introduction:   To show dynamic help text in APEX reports (Interactive/classical) in Oracle APEX 4.2 using CSS.   Solution:   Step 1: Create Interactive report   Step 2: Use below query in…

Read More

Scroll to the top of the page/report in Oracle APEX

Introduction:   To Scroll the top of the page/report in Oracle APEX application.   Scenario:   We have encountered an issue that you always stay on the bottom of the page even after the refresh…

Read More

Multiple Interactive Reports in Single Page Oracle Apex 4.2

Introduction :  In APEX 4.2, we can have only one IR on one APEX page and APEX won’t let us create more. So, we will have to create one IR each on…

Read More