Hi All,
Current TOAD version: 12.6.0.53 Professional Edition.
We are using TOAD code analysis to review our code from last 6 months.
We have now started using json_table but I think TOAD don’t like the syntax of json_table.
select jt.phones
from j_purchaseorder,
json_table(po_document, ‘.ShippingInstructions'
columns
(phones varchar2(100) format json path '.Phone’)) as jt;
It gives below syntax error.
[Error] Syntax check (2: 18): ERROR: line 2, column 18, ending line 2, column 18: Found ‘(’: Expecting: end-of-input -or- FOR ORDER -or- INTERSECT MINUS UNION -or- CONNECT GROUP HAVING START -or- , WHERE -or- AS CROSS FETCH FULL identifier INNER JOIN LEFT LOCATION LOG MATCH_RECOGNIZE MODEL NATURAL OFFSET OUTER PARTITION PIVOT RETURN RETURNING RIGHT SAMPLE SUBPARTITION UNPIVOT USING VERSIONS
Is there any way around this?
Thanks in advance for your help!