For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
The following statement works in Oracle Database 23ai but produces a syntax error in the VS Code extension 24.3.1.
select json_transform('{"a":[1,2,3]}', sort '$.a' order by '$' desc );
Here's the screenshot showing the complete error message:
