Mega Menu Oracle APEX

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 …

Coalesce in oracle

Coalesce in ORACLE COALESCE return first not null value out all the parameter passed into this function. NOTE: All the parameters have be same datatype DROP TABLE coalesce_func_test; CREATE TABLE coalesce_func_test ( id NUMBER, col1 VARCHAR2 (10), col2 VARCHAR2 (10), col3 VARCHAR2 (10), col4 NUMBER ); Sample Data SET …

Coalesce in oracle

Coalesce in ORACLE COALESCE return first not null value out all the parameter passed into this function. NOTE: All the parameters have be same datatype DROP TABLE coalesce_func_test; CREATE TABLE coalesce_func_test ( id NUMBER, col1 VARCHAR2 (10), col2 VARCHAR2 (10), col3 VARCHAR2 (10), col4 NUMBER ); Sample Data SET …

APEX Forms Reloaded Part 3

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 …

New Login Page Template APEX 19 20

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 …

How to Create Sticky Menu Bar

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. position:fixed; top:0px; Let’s check the full example below <html> …

Master Detail Report in APEX

Master Detail Report In APEX | No page load Master Detail Report In APEX for standard pages and Dialog pages. When we are working with Master Detail report pages in Oracle APEX, we need to submit the page to set the value of the row/column in one of the page Item. It works with Standard pages very well. But when you …