JSON syntax and formatter

Toad for Oracle - Beta
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.