Affects PMD Version: 6.10.0-SNAPSHOT
Code Sample demonstrating the issue:
BEGIN
UPDATE someTable
SET colName = 'N'
WHERE id = other_id
AND id NOT IN (SELECT * FROM TABLE(the_expression));
END;
/
This syntax is described here:
https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/SELECT.html#GUID-CFA006CA-6FF1-4972-821E-6996142A51C6__I2065746
https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/SELECT.html#GUID-CFA006CA-6FF1-4972-821E-6996142A51C6
table_collection_expression
The table_collection_expression lets you inform Oracle that the value of collection_expression should
be treated as a table for purposes of query and DML operations. The collection_expression can be a
subquery, a column, a function, or a collection constructor. Regardless of its form, it must return a
collection value—that is, a value whose type is nested table or varray. This process of extracting the
elements of a collection is called collection unnesting.The optional plus (+) is relevant if you are joining the TABLE collection expression with the parent
table. The + creates an outer join of the two, so that the query returns rows from the outer table even
if the collection expression is null.
Running PMD through: Designer
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4