declare
fTrack json;
fData VarChar2(100);
begin
     fTrack := json('{"trackingNumber":"123456123456","history":[{"operationName":"Неудачная попытка вручения","attributeName":"Временное отсутствие адресата","operationDate":"2016-01-21T08:22:00.000+0000","operationZip":"123456"},{"operationName":"Обработка","attributeName":"Передано почтальону","operationDate":"2016-01-21T07:22:00.000+0000","operationZip":"123456"},{"operationName":"Обработка","attributeName":"Прибыло в место вручения","operationDate":"2016-01-21T05:18:00.000+0000","operationZip":"123456"},{"operationName":"Обработка","attributeName":"Покинуло сортировочный центр","operationDate":"2016-01-20T23:35:00.000+0000","operationZip":"123456"},{"operationName":"Обработка","attributeName":"Покинуло сортировочный центр","operationDate":"2016-01-19T08:55:00.000+0000","operationZip":"123456"},{"operationName":"Обработка","attributeName":"Сортировка","operationDate":"2016-01-18T21:55:00.000+0000","operationZip":"123456"},{"operationName":"Обработка","attributeName":"Покинуло сортировочный центр","operationDate":"2016-01-18T16:59:00.000+0000","operationZip":"123456"},{"operationName":"Прием","attributeName":"Партионный","operationDate":"2016-01-18T09:42:00.000+0000","operationZip":"123456"}]}');
     fTrack.print;
     fData := fTrack.get('trackingNumber');
     fData := fTrack.get('history.operationName');
end;