How to search in Json file attached in BLOB field using Oracle 12c?
|Added at||2017-01-05 18:01|
I want search text inside of json. that json is persisted in blob field. I have created the follow table
To persist one row I've used the SQL Develop UI to add all fields value and attach the json file into blob field. The file attached in blob field has json text (huge json).
Example of file
I want to search inside of blob field using path. Like:
I am using the follow query but it's not getting any row
I know that value exists inside json persisted
if I try:
what's the problem?