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

Reading File From Oracle Directory

How to read Files from Oracle Directory using PL/SQL? File Structure ACCOUNTINGRESEARCHSALESOPERATIONS3 Records5 Records6 Records0 Records How to generate files into Oracle Directory? Copy CodeCopiedUse a different Browser DECLARE l_file…
March 29, 2020
Posted inORACLE PLSQL

Writing File to Oracle Directory

How to write file to ORACLE Directory using PL/SQL? Creating directory Copy CodeCopiedUse a different BrowserGRANT CREATE ANY DIRECTORY TO apex_19_2; CREATE OR REPLACE DIRECTORY my_dir AS 'C:\App\MY_DIR'; Writing File…
March 27, 2020