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…
Posted inAPEX
How to Select All Records in Interactive Report Without Any Limitation
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.…
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,…
Posted inORACLE
How to Parse XML in Oracle
How to parse XML using APEX_DATA_PARSER? Get the XML data. Copy CodeCopiedUse a different Browser<?xml version="1.0" encoding="UTF-8"?> <DATA> <ROW> <EMPNO>7839</EMPNO> <ENAME>KING</ENAME> <HIREDATE>1981-11-17</HIREDATE> <SAL>5000</SAL> <DEPTNO>10</DEPTNO> </ROW> <ROW> <EMPNO>7698</EMPNO> <ENAME>BLAKE</ENAME> <HIREDATE>1981-05-01</HIREDATE> <SAL>2850</SAL>…