Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
try this.. SELECT JSON_OBJECT ('SupplierNumber' VALUE ps.segment1, 'VendorType' VALUE ps.vendor_type_lookup_CodeFORMAT JSON) sample_output FROM poz_suppliers ps