CREATE TABLE APPLICATION  
  (  
    applicationId   VARCHAR2(36),  
    customerId      VARCHAR2(36),  
    assignee        VARCHAR2(36),  
    status          VARCHAR2(36),  
    applicationDate TIMESTAMP,  
    closerDueDate   TIMESTAMP,  
    closedDate      TIMESTAMP,  
    application blob ,  
    CONSTRAINT application CHECK(application IS JSON FORMAT JSON)) LOB (application) STORE AS(STORAGE (NEXT 15M))

insert into application (application) values (to_blob(utl_raw.CAST_TO_RAW('{  
   "fields" : {  
        "Customerid" : "AutomationRuleSet"  
   }  
}')))

select app.application  
from application app  
where json_exists(app.application format json, '$.fields.Customerid')

select json_value(app.application format json, '$.fields.Customerid')  
from application app  
where json_value(app.application format json, '$.fields.Customerid') = 'AutomationRuleSet'

select JSON_QUERY(app.application format json, '$.fields')  
from application app

select app.application From application app  
where json_query(app.application, '$.fields.CustomerID') = 'AutomationRuleSet'

drop table application purge