Is there a way to get the last item of a JSON array using a JSON query only (in this case Newtonsoft.Json SelectToken method)? I can not use the Last method from Newtonsoft.Json, as I get the query from a…
I need to do this with Oracle 19c. I have arbitrary json data in a column of a table. I mean, I dont know the names of attributes, not even the deep the data is... Suppose that I can identify…
I have RegEx details table and I want to make array object. I am trying to make JSON using JSON_QUERY() then I getting error like: "JSON text is not properly formatted. Unexpected character '"' is found". It's only getting when…
I have a table in SQL SERVER to keep all of the users app reviews. When the user reviews the app with 4 or 5 stars I recieve a Json like this one { "Calificacion": 5, "Cuestionario": "", "Comentarios": "",…
I wonder if this query is possible using json query. I need to select all records that have more than 3 values a like. for example, I have an array [1,2,3,4,5,6]. Database record has: # ["1","2","3","9","4","2"] selected <--- this contains…