Posted inORACLE SQL

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…
May 21, 2020
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…
May 19, 2020
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…
May 12, 2020
Posted inORACLE PLSQL

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…
April 30, 2020
Posted inAPEX

2 Ways to Make Column nowrap Interactive Report Oracle APEX

SOLUTION 1: Column Formatting => HTML Expression: <span style="white-space:nowrap;">#COLUMN_NAME#</span> SOLUTION 2: Define region Id “regionId” and Column id “HIRE_ID” after that use following CSS: #regionId th#HIRE_ID, #regionId td[headers=HIRE_ID]{min-width:100px}
April 23, 2020
Posted inAPEX ORACLE

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,…
April 19, 2020