How to Calculate total sum of interactive grid column into page item in oracle APEX. Most of the time, this question was asked by my friends and colleagues that “How to Calculate total sum of interactive grid column into page item in oracle APEX” then i got solution in two ways. Solution 1. Need to create …

Read More

How Add Tooltip on Side Navigation Menu Oracle APEX. In Apex, If You create an application with Side navigation menu and navigation menu name is too long in this case apex will not show full navigation name in this case tool tip will help you alot. There are simple steps to achieve this tool-tip functionality. In …

Read More

Creating a custom template. Templates are organized first by a template type and then by template class. Template types include page, region, report, list, button, label, and popup list of values (LOV). You can use template options to apply different colors or accents, different spacing and padding, and display form …

Read More

How to Add Search Option On Nav Bar Oracle APEX In Some of the cases wee need to add search field of top of the navigation bar but directly we can’t add it so there is the solution if we edit tamplate so lets start and see how we can get. First go to the Share Components»Templates and copy the navigation …

Read More

Here is the requirement for refreshing the report on base page,to do so i am just creating a Dynamic Action (DA) :- Parent Page : Create Dynamic action Event > Dialog Closed Selection type > Javascript Expression Condition > JavaScript Expression> window If You are working with above Apex 5.0 then …

Read More

Checkboxes are little bit tricky and difficult. I was trying to implement it for long time but it’s bit problematic than i thought. After John Snyders cookbook update for 19.2 things are very easy. I would recomend to go through Jhon’s Updates He has implemented the checkbox in Interactive Grid. I have …

Read More

Mega Menu Oracle Apex Mega Menu is collapsible floating panel which displays navigation entries at once. It enables users to reduce number of clicks to navigate. Features of Mega Menu Customizable Icons, Descriptions, and Badges Responsive Accessible and Keyboard Friendly How to create? Mega menu can use the exiting …

Read More

How to check duplicate record in table SQL/Oracle? Create table using following script: 1CREATE TABLE TEST_EMP 2( 3 ENAME VARCHAR2(10 BYTE), 4 DEPTNO NUMBER(2), 5 ID NUMBER 6) Run following script for demo purpose. 1SET DEFINE OFF; 2Insert into TEST_EMP (ENAME, DEPTNO, ID) 3 Values ('SMITH', 20, 1); 4Insert …

Read More

How to delete duplicate record From table using SQL/Oracle? Create table using following script: 1CREATE TABLE TEST_EMP 2( 3 ENAME VARCHAR2(10 BYTE), 4 DEPTNO NUMBER(2), 5 ID NUMBER 6) Run following script for demo purpose. 1SET DEFINE OFF; 2Insert into TEST_EMP (ENAME, DEPTNO, ID) 3 Values ('SMITH', 20, …

Read More

How to set the Application header with text in ORACLE APEX? We have been asked about setting up the Application logo with the text string. Let’s take a look version by version. APEX 5 and APEX 18 In APEX 5 and APEX 18 we can only set up a logo or text at a time. So what if we need to display text and logo …

Read More