create   table json_storage (
id number not null,
created_dtm timestamp not null,
json_data blob
);

CREATE  INDEX json_fts_idx ON json_storage (json_data)
  INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS ('section group CTXSYS.JSON_SECTION_GROUP SYNC (EVERY "SYSDATE+1/24") transactional') ;

insert into json_storage(id, created_dtm, json_data)
   values(
   -1000,
   systimestamp,
   utl_raw.cast_to_raw('
                         {"menu": {
                        "id": "' || '444444444'  ||'",
                        "value": "File",
                        "popup": {
                          "menuitem": [
                            {"value": "New", "onclick": "CreateNewDoc()"},
                            {"value": "Open", "onclick": "OpenDoc()"},
                            {"value": "Close", "onclick": "CloseDoc()"}
                          ]
                        }
                      }}
                       '
                    )
   );

 select JSON_VALUE(json_data, '$.menu.id')
from json_storage
where json_textcontains(json_data, '$.menu.id', '4444444449') ;

select JSON_VALUE(json_data, '$.menu.id')
from json_storage
where contains(json_data, '4444444449 INPATCH(/menu/id)') >0;

select JSON_VALUE(json_data, '$.menu.id')
from json_storage
where contains(json_data, '4444444449') >0;

 begin
    ctx_ddl.SYNC_INDEX('PERSO.json_fts_idx'); --schema inside :)
   end;

select JSON_VALUE(json_data, '$.menu.id')
from json_storage
where contains(json_data, '4444444449 INPACH(/menu/id)') >0;