Re: json_table - get entire array

hi
give a "minimal reproducible example" (MRE) so we can help and pinpoint the issue right away.... anonymize data or tag if that's the concern...bye

On Tuesday, July 15, 2025 at 05:55:22 PM GMT+2, Jay Vaughn <jeffersonvaughn@xxxxxxxxx> wrote:

I'm curious about a concept with json_table...

Given the below statement (which is invalid due to the "columns('$')")...
Is there any possible way to have the statement select the entire orders
array, sub array/objects, etc, without having to define that entire
array/subarray/objects DS  for that orders array?

select *
from *json_table*(*trim*(jvaughn.tempjson1)
              ,'$' columns(NESTED '$.orders[*]'
                            columns('$')
                          )
                  ) as t
where "dtNr" = '78714';

tia

Jay V