Important Announcement
This forum will be discontinued.
The creation of new topics is disabled.
Please open GitHub issues for the corresponding topics/products in the following Trivadis repositories:
- PL/SQL & SQL Coding Guidelines
- PL/SQL Cop Command Line
- PL/SQL Cop for SonarQube
- PL/SQL Cop for SQL Developer
- PL/SQL Cop Validators
- PL/SQL Analyzer
- PL/SQL Unwrapper
A lot of users have already a GitHub account and the management of the issues is better than in this forum. For example, closing a forum topic is never related to a product change. Closing a GitHub issue for an accepted bug means that the bug is fixed. This should simplify the work for all involved parties.
See this blog post for more information.
Thank you for your understanding.
Aha, indeed objects with name "json" broke the COP's haven. with ajson as ( select '{"bla_bla_bla":"Why we have ten E-0002 issues now?"}' doc from dua...
much more interesting sample: with json as ( select '{"bla_bla_bla":"Why we have ten E-0002 issues now?"}' doc from dual ) SELECT *FROM json_table( (s...
Nice shoot, Philipp. You are right in sense of publicly available syntax for JSON_TABLE function: , but reality is more complicated. create view v1asS...