Toad World® Forums

JSON syntax and formatter


The JSON syntax (new in is generating syntax error in Toad

Example from the doc

/* Formatted on 07/10/2014 14:51:58 (QP5 v5.270.14245.40064) */

SELECT jt.phones

FROM j_purchaseorder, JSON_TABLE(po_document, ‘$.ShippingInstructions’


(phones VARCHAR2(100) FORMAT JSON PATH ‘$.Phone’)) AS jt;

[Error] Syntax check (3: 35):


JSON syntax coding just got finished, it’s on its way to production …




in QP5 v5.272.14308.31872, I have no more syntax error, but it is not formatting at all


Not all new Oracle 12c formatting has been updated yet. Expect that as of mid Jan.