-
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 -
Preserve Checkbox state while Paginating in Interactive/Classic Report Oracle APEX Someone has asked this question to me that how can we preserve checked checkboxes in session state. This Problem will come when the user will check few checkboxes and go to next set of rows via pagination in the report when user will go …
Read More -
Auto New Line Generation in Interactive Grid Oracle APEX Sometimes user don’t want to go with add row button for a new row generation on those cases I will show you how to generate new line without using add row button. for this, you will have to follow some simple steps: Create Interactive grid using following …
Read More -
Auto validation Forms APEX 19 | Part 3 In our tradisional forms we have to write additional code for preventing invalid rows or putting any validation. APEX 19 forms came up with a concept where you can define the row qualifier in query and that’s it, Form will automatically prevent the any invalid row. Create …
Read More -
New Login Page template APEX 19 / 20.1 APEX 19 came with New LOGIN page design. Now screen can be display as splitted. Let’s try. We need to change the template type There are two Page layouts Floating Split Floating is old layout, try with split. Select Split layout, save and run. We can use backgrounds as …
Read More -
How to create sticky header using CSS? To create sticky menu we need to make sure the div must be at the top of the page and stays there when page gets scroll. How do we do that? Make div Position Fixed Define position from TOP. 1 position:fixed; 2 top:0px; Let’s check the full example below 1<html> …
Read More -
Select All records in Interactive Report without any limitation Oracle APEX How to select all records in Interactive Report without any limitation Oracle APEX This approach can be used in case of when a single pagination has more than 50 records. Create a table which has large no of records i.e. INDIA_PINCODE. Create …
Read More -
Apex Data Parser - How to Parse XLSX and CSV? PARSE Function This is the main parser function. It allows to parse XML, XLSX, CSV or JSON files and returns a generic table of the following structure: Structure of parser return LINE_NUMBER, COL001, COL002, COL003, COL004 … COL300 We have line_number and 300 …
Read More -
Refresh Static region DATA in Oracle APEX I have been receiving couple of queries about the static region refresh. In this article, I’ll try to get through it. Background: In the Interactive and classic reports data refresh from database is done by AJAX. APEX internally calls the AJAX callback to fetch the data …
Read More