Oracle NVL Function
The NVL function allows you to replace null values with a default values. If the first parameter is null, the function returns the second parameter. If the first parameter has…
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 returns the default value. The Oracle/PLSQL DECODE function…
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…
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…
Remove Special Character and Extra Space From a String ORACLE/PLSQL
Removing special character using REGEXP: SELECT REGEXP_REPLACE('Sahay*)(^#@Pandey$ashish/Vikas','[^a-z_A-Z ]') FROM DUAL; Remove extra spaces between string using REGEXP: Copy CodeCopiedUse a different BrowserSELECT REGEXP_REPLACE ('Vikas Pandey from Delhi', '[[:blank:]]+', ' ')…
How to Remove New line from a String Using PL/SQL/ORACLE?
To Remove New line from the string: Copy CodeCopiedUse a different BrowserDECLARE p_sting VARCHAR2 (100) := 'This is Vikas from Delhi Now the next line. '; BEGIN DBMS_OUTPUT.put_line (p_sting); DBMS_OUTPUT.put_line…