skip to Main Content

Translate JSON data into ORACLE sql table

``` select JT.* FROM JSON_TABLE (json_sample) '$.general[*]' COLUMNS ( product_key NUMBER PATH '$.product_key', group_subtype_id NUMBER PATH '$.group_subtype_id', group_subtype_name VARCHAR2 ( 100 ) PATH '$.group_subtype_name', variant_id NUMBER PATH '$.variant_id', variant_name VARCHAR2 ( 100 ) PATH '$.variant_name', rb_customer_id NUMBER PATH '$.rb_customer_id', NESTED…

VIEW QUESTION

json string is not converting to model

I have json response as below. {"StatusCode":1,"Data":{"AndroidVersion":"1","IOSVersion":"1"},"Pager":null,"Error":null} Now I want to convert to model where I have string extension as below. func toJSON() -> Any? { guard let data = self.data(using: .utf8, allowLossyConversion: false) else { return nil } return…

VIEW QUESTION
Back To Top
Search