Hi Tom,

I have a query ,I want to pass multiple values to pbd_prod_code is this possible ,as I am getting null v after passing 1001,1002 values to the parameter

SELECT field_key,
field_lable,
FROM json_table(
(SELECT PBD_BLOCK_INFO
FROM PIIM_PROD_BLOCK_DEFN_TEST
WHERE PBD_PROD_CODE in (:PBD_PROD_CODE)
AND PBD_BLOCK_ID = :PBD_BLOCK_ID ),
'$[*]' COLUMNS(field_lable path '$.fieldlabel',
field_key path '$.fieldkeyid'));