Oracle execute syntax
I am running select queries in Oracle execute. They run fine but i have 2 issues. I am unable to use any where clauses and I am unable to do any kind of date formatting in the mapper. For example, i ...
Forum Discussion
Thanks Alchemiz , the array is now spliited in two. One array with 100 elements and the other with the remaining elements.
This is the current output :
"ShipmentCreateDate": "01/01/2023",
"ShipmentID": "1",
"SerialNumbers": [
[
{
"SerialNo": "123"
},
{ "SerialNo":"456"
}
],
[
{
"SerialNo": "101"
},
{
"SerialNo": "102"
}
]
]
I was wondering if something like this output is possible :
"ShipmentCreateDate": "01/01/2023",
"ShipmentID": "1",
"SerialNumbers": [
[
{
"SerialNo": "123"
},
{
"SerialNo":"456"
}
]
"ShipmentCreateDate": "01/01/2023",
"ShipmentID": "1",
"SerialNumbers": [
[
{
"SerialNo": "101"
},
{
"SerialNo": "102"
}
]
]
Where the first output would be the array with the 100 elements and the remaining fields that are not part of the array and the second output would be the array with the remaining elements and the fields that are not part of the array.
Regards,
Igor
Thanks this is what i was exactly looking for.
