CREATE TABLE example (doc CLOB CONSTRAINT doc_valid_json CHECK (doc IS JSON))

INSERT INTO example (doc) VALUES (' 
[ 
    { 
        "foo": "100083087", 
        "bar": [ 
            { 
                "let": "DIV", 
                "letID": "100083088" 
            } 
        ] 
    }, 
    { 
        "foo": "100032830", 
        "bar": [ 
            { 
                "let": "DIV", 
                "letID": "1000832333" 
            }, 
            { 
                "let": "TET", 
                "letID": "2234832333" 
            } 
        ] 
    } 
]')

commit