Table Blob to Oracle Directory
Posted inORACLE PLSQL

Table Blob to Oracle Directory

How to save table images to oracle directory? Files from table to Oracle directory Copy CodeCopiedUse a different BrowserDECLARE l_file UTL_FILE.file_type; l_buffer RAW (32767); l_amount BINARY_INTEGER := 32767; l_position INTEGER…
June 20, 2020
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 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