Dynamic position Navigation Menu Oracle APEX
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…
Posted inAPEX IG Interactive Grid
Interactive Grid Checkbox
Referred from John’s cookbook sample app. 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…
Posted inAPEX
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…
Table Blob to Oracle Directory
How to save table images to oracle directory? Files from table to Oracle directory Copy CodeCopiedUse a different BrowserDECLARE l_file UTL_FILE.file_type; l_buffer RAW (32767); l_amount BINARY_INTEGER := 32767; l_position INTEGER…
Posted inAPEX
Application header with text in ORACLE APEX
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…
Coalesce in oracle
COALESCE returns first not null value out of all the parameters passed into this function. NOTE: All the parameters have been the same datatype Copy CodeCopiedUse a different BrowserDROP TABLE coalesce_func_test; CREATE…
Posted inAPEX
Oracle APEX Multi Language translation
How to translate Oracle APEX into Multi-Languages? In application development, multilanguage translation is always a tedious job to accomplish. But when it comes to APEX is just like a couple…
Posted inSQL
NULL in ORACLE
NULL in Oracle NULL = NULL ? Copy CodeCopiedUse a different BrowserSELECT CASE WHEN NULL = NULL THEN 'NULL Equals to NULL' ELSE 'NULL is NOT Equals to NULL' END…
Cursors in PL/SQL
What is cursor: Pointer to the memory location where the information about sql stmt or DML statement got executed. There are two types of cursors − Implicit Cursor:= Any Select Stmt Or…
How to Parse JSON Using APEX Data Parser in Oracle?
How to Parse Json Using APEX Data Parser in Oracle? Sample JSON Copy CodeCopiedUse a different Browser{ "items":[ { "uri":{ "$ref":"https://apex.oracle.com/pls/apex/ashish_portfolio/hr/employeesfeed/7782" }, "empno":7782, "ename":"CLARK" }, { "uri":{ "$ref":"https://apex.oracle.com/pls/apex/ashish_portfolio/hr/employeesfeed/7839" }, "empno":7839,…