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,…
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>…
How to Generate XML in Oracle Using SQL
Copy CodeCopiedUse a different BrowserSELECT XMLELEMENT ("ROW", XMLFOREST (empno, ename, hiredate, sal, deptno, mgr, comm)) FROM emp; You might like How to parse XLSX and CSV? How to parse JSON…
APEX Data Parser – How to Parse XLSX and CSV
APEX Data Parser - How to Parse XLSX and CSV? PARSE Function This is the main parser function. It allows to parse XML, XLSX, CSV or JSON files and returns…
Posted inAPEX
Responsive Classic Report in ORACLE APEX
Referred from somewhere i have seen this trick years ago, When i wan not able find that again I have added into my Archive list. If i find this again…
Pipelined Functions in Oracle
How to create Pipelined Functions in Oracle? Pipeline functions are used to return data in tabular format. It returns the data in the nested table type. Pipeline functions are useful…