Why APEX Plugins?

Why APEX Plugins? Oracle application express or widely known as APEX is a great framework that comes up with endless possibilities. Forms, Reports flexible and responsible designs which help to make your app platform-independent. JavaScript, CSS, JQuery, third-party library integration, Plugins, Templates and whatnot. …

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 …