Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How we can compare the two JSON stored in a CLOB datatype in Oracle DB

Hi Team, I have a table wherein I am storing the JSON in CLOB. Now if for one booking, we get two JSON I would like to identify the delta records comparing the two JSON stored in CLOB.

How can we achieve this using SQL/PLSQL

Comments
Post Details
Added on Jan 11 2025
10 comments
476 views