The Code Analysis CRUD matrix results for code that has an INSERT statement which includes sub-selects, is flagging the subselect tables under the C(create) column. These are select statements and should not be flagged under the C column. e.g.
INSERT INTO TEST
(a,b,c)
(SELECT AA,
BB,
CC
FROM
(SELECT MAX(a) +1 AA FROM TEST_A),
(SELECT 'new' BB,
'old' CC FROM dual));
The above code is flagging TEST, TEST_A and DUAL as C (Create) when only TEST should be flagged.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center