Toad World® Forums

JSON syntax and formatter


#1

The JSON syntax (new in 12.1.0.2) is generating syntax error in Toad 12.7.0.4

Example from the doc

http://docs.oracle.com/database/121/SQLRF/functions091.htm#CJAEJCEF

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

SELECT jt.phones

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

COLUMNS

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

[Error] Syntax check (3: 35):


#2

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

Thanks,

Andre


#3

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


#4

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