select j.*
from json_table( '{
                     "BLETest":
                     [{
                       "name": "Employee",
                       "description": "Test Bluetooth Scan",
                       "nbrscan": 2,
                       "starttime": "31-07-2018 23:12:02",
                       "scanperiodicity": 20,
                       "scanduration": 15,
                       "phoneidentifier": "undefined",
                       "phonebrand": "Lenovo",
                       "phonemodel": "P2",
                       "requestedgpsaccuracy": "98" ,

                       "BLEScanList":
                       [
			{  "startwgs84longitude":"12.3456",
                           "startwgs84latitude":"23.45678",
                           "startgpsaccuracy":"23",
                           "starttime":"06-07-2018 09:20:09",
                           "stopwgs84longitude":"undefined",
                           "stopwgs84latitude":"undefined",
                           "stopgpsaccuracy":"undefined",
                           "stoptime":"05-07-2017 09:20:29",
                           "phonebatterylevel":77,

                       "BLEScanObjectList":[
                                            {"name":"BPUCK ID 000020","id":"C3:5E:45:15:70:C2","advertising":{},"rssi":-65},
                                            {"id":"60:F8:1D:BA:E0:43","advertising":{},"rssi":-71},
                                            {"name":"BPUCK ID 000015","id":"E8:3D:8F:B3:40:05","advertising":{},"rssi":-81},
                                            {"id":"F2:69:DC:5B:0B:17","advertising":{},"rssi":-70},
                                            {"name":"BPUCK ID 00002B","id":"DA:09:32:B9:87:D3","advertising":{},"rssi":-75},
                                            {"name":"BPUCK ID 00002D","id":"F9:45:D5:B1:6A:DD","advertising":{},"rssi":-67},
                                            {"id":"1D:F0:2A:48:28:1B","advertising":{},"rssi":-65},
                                            {"id":"07:C9:58:F2:32:EE","advertising":{},"rssi":-84},
                                            {"id":"2E:0C:91:FE:3D:C2","advertising":{},"rssi":-88},
                                            {"id":"2C:6B:0B:19:0A:27","advertising":{},"rssi":-91},
                                            {"id":"F1:61:22:84:29:12","advertising":{},"rssi":-92},
                                            {"id":"46:83:6B:62:22:1F","advertising":{},"rssi":-100},
                                            {"id":"4F:8F:8A:6E:52:49","advertising":{},"rssi":-82},
                                            {"id":"DA:C3:C4:13:0E:28","advertising":{},"rssi":-74},
                                            {"id":"01:25:24:3C:4A:7E","advertising":{},"rssi":-88},
                                            {"id":"78:4F:43:84:B3:67","advertising":{},"rssi":-87},
                                            {"id":"F1:68:DB:5A:0A:16","advertising":{},"rssi":-86},
                                            {"id":"E8:3F:3E:EF:F4:DA","advertising":{},"rssi":-83},
                                            {"id":"75:22:49:36:A8:D8","advertising":{},"rssi":-70},
                                            {"id":"1A:D5:86:5B:95:D4","advertising":{},"rssi":-90},
                                            {"id":"EF:5F:20:82:27:10","advertising":{},"rssi":-89},
                                            {"id":"E1:A4:21:BF:DD:9C","advertising":{},"rssi":-89},
                                            {"id":"26:A7:91:D8:58:02","advertising":{},"rssi":-97},
                                            {"id":"5D:5A:9E:49:15:AA","advertising":{},"rssi":-79},
                                            {"id":"F3:6A:DD:5C:0C:18","advertising":{},"rssi":-88},
                                            {"id":"D0:99:26:A7:F7:EB","advertising":{},"rssi":-77},
                                            {"id":"D0:A0:DF:7D:D8:EF","advertising":{},"rssi":-85},
                                            {"id":"E3:A6:23:C1:DF:9E","advertising":{},"rssi":-84},
                                            {"id":"F2:62:23:85:2A:13","advertising":{},"rssi":-70},
                                            {"id":"EF:66:D9:58:08:14","advertising":{},"rssi":-81},
                                            {"name":"BPUCK ID 00002A","id":"DD:B9:75:55:D5:2A","advertising":{},"rssi":-79},
                                            {"name":"BPUCK ID 00001D","id":"DF:35:EE:8B:6F:79","advertising":{},"rssi":-73},
                                            {"id":"D7:C0:C1:10:0B:25","advertising":{},"rssi":-81},
                                            {"id":"D9:C2:C3:12:0D:27","advertising":{},"rssi":-88},
                                            {"name":"BPUCK ID 000018","id":"FB:4A:F8:90:71:BD","advertising":{},"rssi":-73},
                                            {"name":"BPUCK ID 000013","id":"C4:75:F6:49:97:82","advertising":{},"rssi":-71},
                                            {"name":"BPUCK ID 000010","id":"E6:31:30:F3:F0:1B","advertising":{},"rssi":-72}

                                           ]
		     },
		     {     "startwgs84longitude":"00.000123",
                           "startwgs84latitude":"undefined",
                           "startgpsaccuracy":"undefined",
                           "starttime":"52-07-2018 09:20:08",
                           "stopwgs84longitude":"undefined",
                           "stopwgs84latitude":"54.64323",
                           "stopgpsaccuracy":"undefined",
                           "stoptime":"06-07-2018 09:20:29",
                           "phonebatterylevel":98,

                       "BLEScanObjectList":[
                                            {"name":"BPUCK ID 000020","id":"C3:5E:45:15:70:C2","advertising":{},"rssi":-100}

			                   ]
	            }
                   ]
		}
	]
}',  '$.BLETest[*]'
             columns (
             name varchar2(50 byte) path '$.name',
             description varchar2(500 byte) path '$.description',
             nbr_scan number(10,0) path '$.nbrscan',
             start_time varchar2 path '$.starttime',
             scan_periodicity number(10,0) path '$.scanperiodicity',
             scan_duration number(10,5) path '$.scanduration',
             phone_identifier varchar2(200 byte) path '$.phoneidentifier',
             phone_brand varchar2(50 byte) path '$.phonebrand',
             phone_model varchar2(50 byte) path '$.phonemodel',
             requested_gps_accuracy number(10,0) path '$.requestedgpsaccuracy',
             nested path '$.BLEScanList[*]'
             columns (
                      start_wgs84_longitude number(10,5) path '$.startwgs84longitude',
                      start_wgs84_latitude number(10,5) path '$.startwgs84latitude',
                      start_gps_accuracy number(10,0) path '$.startgpsaccuracy',
                      scan_start_time varchar2 path '$.starttime',
                      stop_wgs84_longitude number(10,5) path '$.stopwgs84longitude',
                      stop_wgs84_latitude number(10,5) path '$.stopwgs84latitude',
                      stop_gps_accuracy number(10,0) path '$.stopgpsaccuracy',
                      stop_time varchar2 path '$.stoptime',
                      phone_battery_level number(10,0) path '$.phonebatterylevel',
                      nested path '$.BLEScanObjectList[*]'
                      columns (
                               mac varchar2(20 byte) path '$.id',
                               device_name varchar2(200 byte) path '$.name',
                               rssi number(15,5) path '$.rssi'
                              )
                     )
           )
                )   j;