Oracle Dewdrops - May 2025

Dewdrop #82 25-Apr-25

Index fast full scan

Dewdrop #81 24-May-25

Working with JSONs in Oracle

Dewdrop #80 12-May-25

A generic JSON parser and JSON generator using a config table

Dewdrop #79 12-May-25

A generic JSON generator using a config table

Dewdrop #78 20-Jun-25

JSON_TRANSFORM using the REMOVE clause to remove a tag element for a JSON

Dewdrop #77 19-Jun-25

JSON_TRANSFORM using the UPDATE clause

Dewdrop #76 30-May-25

JSON_TRANSFORM with SET to append complex JSON object types to the JSON

Dewdrop #75 18-Jun-25

JSON_TRANSFORM using the INSERT clause

Dewdrop #74 13-Jun-25

JSON_TRANSFORM with SET to add a new element to the JSON

Dewdrop #73 16-Jun-25

JSON_TRANSFORM with SET to modify an existing tag value

Dewdrop #72 30-May-25

SELECT individual elements from a JSON having individual elements, arrays and objects using JSON_VALUE

Dewdrop #71 13-May-25

GET_ARRAY method in JSON

Dewdrop #70 03-May-25

GET_OBJECT method in JSON

God's Word for the day

Do not kindle the coal of sinners

  or you may be burned in their flaming fire.

Do not let the insolent bring you to your feet

  or they may lie in ambush against your words.

Do not lend to one who is stronger than you

  but if you do lend anything count it as a loss.

Do not give surety beyond your means;

  but if you give a surety be prepared to pay.

Sirach 8:10-13