CREATE TABLE metering 
   (id          RAW (16) NOT NULL, 
    date_loaded TIMESTAMP WITH TIME ZONE, 
    jsonmeteringdata CLOB 
    CONSTRAINT ensure_metering_json CHECK (jsonmeteringdata IS JSON))

    CREATE BITMAP INDEX metering_servicename_idx 
  ON metering (json_exists(jsonmeteringdata,  
                                  '$.serviceName'))

CREATE BITMAP INDEX has_resourcename_idx 
  ON metering (json_exists(jsonmeteringdata,  
                                  '$.resourceName'))

create view v_metering as select met.id, met.jsonmeteringdata.startTimeUtc, met.jsonmeteringdata.endTimeUtc, 
    met.jsonmeteringdata.serviceName, met.jsonmeteringdata.resourceName,  
    met.jsonmeteringdata.costs.unitPrice P, met.jsonmeteringdata.costs.computedQuantity Q,  
    met.jsonmeteringdata.costs.computedAmount Money, met.jsonmeteringdata.costs.overagesFlag Overage, 
    met.jsonmeteringdata.costs.computeType comptype 
    from metering met

 INSERT INTO metering 
  VALUES ( 
    SYS_GUID(), 
    SYSTIMESTAMP, 
    '{ 
		"subscriptionId": "7071695", 
		"subscriptionType": "PRODUCTION", 
		"serviceName": "Compute", 
		"resourceName": "BLOCK_STORAGE", 
		"currency": "EUR", 
		"gsiProductId": "B88274", 
		"startTimeUtc": "2019-01-01T00:00:00.000", 
		"endTimeUtc": "2019-02-01T00:00:00.000", 
		"dataCenterId": "EM003", 
		"serviceEntitlementId": "603784705", 
		"costs": [{ 
			"computedQuantity": 1047.4112903225807, 
			"computedAmount": 29.0429677444, 
			"unitPrice": 0.0295, 
			"overagesFlag": "N", 
			"computeType": "Usage" 
		}] 
	}' 
    )

select met.id, met.jsonmeteringdata.startTimeUtc, met.jsonmeteringdata.endTimeUtc, 
    met.jsonmeteringdata.serviceName, met.jsonmeteringdata.resourceName,  
    met.jsonmeteringdata.costs.unitPrice P, met.jsonmeteringdata.costs.computedQuantity Q,  
    met.jsonmeteringdata.costs.computedAmount Money, met.jsonmeteringdata.costs.overagesFlag Overage, 
    met.jsonmeteringdata.costs.computeType comptype 
    from metering met

select * from v_metering