Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Hello,
- Since Nikola is on a holiday I am answering this email for him.
- Here is an example of the limit of the characters that can be read from a single json.
- If a the yellow 111111 is deleted the lines are 26 otherwise the lines are 24. The JSON string after the character limit is ignored.
- 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":-65111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111},
- {"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;
- Regards,
- Yordan
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement