Ontoor blogs

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>…

Ashish Sahay April 19, 2020

ORACLE SQL

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…

Ashish Sahay April 19, 2020

APEX ORACLE

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…

Ashish Sahay April 18, 2020

APEX

Preview an Image Before Upload Oracle APEX

Sometimes we face the requirement like how to show the image before image upload. There are some easy steps to preview images before upload. Create a blank page with two…

Vikas Pandey April 15, 2020

APEX

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…

Ashish Sahay April 14, 2020

ORACLE SQL

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:]]+', ' ')…

Vikas Pandey April 13, 2020

APEX

4 Ways to Open Inline Dialog Using jQuery Oracle APEX

In this article, you can learn how to open an inline modal dialog in Oracle Apex. There are different ways to open modal dialog using simple JQuery. Inline modal dialog…

Vikas Pandey April 12, 2020

ORACLE SQL

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…

Vikas Pandey April 12, 2020

ORACLE PLSQL

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…

Ashish Sahay April 12, 2020

APEX

Preserve Checkbox state while Paginating in Interactive/Classic Report Oracle APEX

Someone has asked this question to me how can we preserve checked checkboxes in the session state.This Problem will come when the user checks a few checkboxes and goes to…

Vikas Pandey April 11, 2020