Hi! I am currently trying to write some SQL queries to extract specific values out of JSON stored in our database as a CLOB data type.
I am using SQL Developer Version 23.1.0.097 (Build 097.1607).
In my query, I have code such as: ELSE JSON_UNQUOTE(JSON_EXTRACT(a.OBJECT, '$[0]'))
But I am getting errors when I try to run the code.
From what I can see, it looks like these JSON functions, are supported in Oracle and in SQL Developer specifically, but maybe there is an extension or a plug-in needed? Or do I need to somehow declare something in order to use these features? Any advice would be greatly appreciated.