Dynamic position navigation menu As a developer we know how to change the Navigation menu position. We have access to change the navigation menu position but when it comes to user then there is hard and forced fixed menu position is offered to user. It was all history until it came to John Snyders. There are multiple …

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 save table images to oracle directory? Files from table to Oracle directory 1DECLARE 2 l_file UTL_FILE.file_type; 3 l_buffer RAW (32767); 4 l_amount BINARY_INTEGER := 32767; 5 l_position INTEGER := 1; 6 l_blob_length INTEGER; 7BEGIN 8 FOR l_cnt IN (SELECT filename, product_image FROM demo_product_info) 9 LOOP 10 …

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

Oracle NULLIF() Function: The Oracle NULLIF() function accepts only two arguments. If the both arguments are equal it returns a null value. In case the arguments are not equal, the NULLIF() function returns the first argument and if any arguments will null then function return an error. Syntax of the NULLIF() …

Read More

Oracle NVL2 Function: NVL2() function is an extend version of the NVL() function with different options based on whether a NULL value exists. Oracle NVL2() function allow three parameters. If the first parameter is not null, then it returns the second parameter. In case the second parameter is null, then it returns the …

Read More

Oracle Decode Function: Oracle DECODE() function compares the first argument with the second argument. IF they are equal, the function returns the third argument otherwise return default value. The Oracle/PLSQL DECODE function has the functionality of an IF-THEN-ELSE statement: 1SELECT DECODE (1, 1, 'ONE', …

Read More

Oracle NVL Function: The NVL function allow you to replace null values with a default value. If the first parameter is null, the function returns the second parameter. If the first parameter have some value then always return first value. Note := NVL function replaces null value with same type data. Syntax of the …

Read More