Hi,
I am using the below query in Oracle*Forms 12 to generate a dynamic LOV with this query in it's record group.
The JSON part of the query is returned to Oracle*Forms by a webservice so I cannot change that.
My question is:
Why does this query only returns 29 rows instead of the 43 ‘rows’ present in the JSON part ?
I am a JSON novice.
Thanks
select * FROM JSON_TABLE ('{"crsl":200,"streetaddress":[
{"streetnames":{"streetcode":16000001,"streetname":"ACACIALAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000004,"streetname":"ANEMOONLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000012,"streetname":"BEUKENLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000201,"streetname":"COLOMALAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000028,"streetname":"DAUWDEFOSSEZLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000200,"streetname":"DE LIMBURG STIRUMLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000033,"streetname":"DENNENLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000040,"streetname":"EIKLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000041,"streetname":"ESDOORNLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000042,"streetname":"EUROPALAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000043,"streetname":"FAZANTENLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000047,"streetname":"GASPELDOORNLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000186,"streetname":"GLADIOLENLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000218,"streetname":"GODFRIED VAN LEUVENLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000058,"streetname":"HERFSTLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000066,"streetname":"JASMIJNLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000083,"streetname":"LENTELAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000078,"streetname":"LEON KREPERLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000084,"streetname":"LIJSTERSLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000187,"streetname":"MADELIEFJESLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000220,"streetname":"MAGNOLIALAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000096,"streetname":"NIEUWENHOVENLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000098,"streetname":"NOTELARENLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000099,"streetname":"OLMENLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000104,"streetname":"PALMENLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000108,"streetname":"PATER DAMIAANLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000109,"streetname":"PATRIJZENLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000114,"streetname":"PLATANENLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000115,"streetname":"POPULIERENLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000217,"streetname":"PRIORIJLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000175,"streetname":"SPORTLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000178,"streetname":"STIJN STREUVELSLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000188,"streetname":"T''SERCLAESLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000197,"streetname":"VAN DER DILFTLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000185,"streetname":"VLEZENBEEKLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000156,"streetname":"WATERMOLENLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000160,"streetname":"WILDERKASTEELLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000161,"streetname":"WILGENLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000162,"streetname":"WINTERLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000211,"streetname":"WOUDMEESTERLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000167,"streetname":"ZOMERLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000169,"streetname":"ZUUNBEEKLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true},
{"streetnames":{"streetcode":16000170,"streetname":"ZUUNDALLAAN","setStreetcode":true,"setStreetname":true},"setStreetnames":true}],
"setCrsl":true,"setStreetaddress":true}'
COLUMNS NESTED PATH '$.streetaddress[*].streetnames[*]' COLUMNS (street VARCHAR2(43) PATH '$.streetname'))