PostgreSQL as an Oracle Alternative
Posted inORACLE PostgreS

PostgreSQL as an Oracle Alternative

Usage, Real-World Fit, and Feature Comparison In the last few years, PostgreSQL has moved from being “just another open-source database” to a serious enterprise-grade option. Many teams that traditionally depended…
Working with JSON_MERGEPATCH
Posted inAPEX ORACLE

Working with JSON_MERGEPATCH

JSON_MERGEPATCH function is very useful to update JSON nodes in JSON documents. We can simply pass the JSON required JSON patch to merge with the existing JSON document using the…
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,…
Posted inAPEX

Generating JSON using APEX_JSON

Generating JSON using APEX_JSON Sample tables from Oracle Create Two table based on below query and Inserted some record for demo purpose: Copy CodeCopiedUse a different BrowserCREATE TABLE DEPT (…