Code Analysis Rule 2750 False Positive
Code Analysis Rule 2750 (“List columns explicitly in your INSERT statement”) : False positive on INSERT statements with a record type VALUES clause. For instance,
CREATE OR REPLACE PROCEDURE T3E (p IN OUT t3%ROWTYPE) IS BEGIN p.a := 3; INSERT INTO t3 VALUES p; -- okay (record type) END;
Formatter Chinese Options screen
In the Chinese version of the Options screen, selecting the Newline and DDL Statement panes did cause a nagging prompt “Attempted an unsupported operation”, due garbled layout of some controls on those panes.
New Code Analysis Rule 6417
Code Analysis: New Rule 6417 (“Avoid natural joins.”)
String ‘–’ inside a hint
A ‘–’ string inside a
/*+ ... */ style hint causes Oracle to choke. This is the case in both Oracle 9i and 12g. The parser will now mimic this bug and yield an error “Oracle does not allow the string ‘–’ in a hint”.
Terminator with SET BLANKLINES OFF
SET SQLBLANKLINES OFF a terminating blank line caused a non-terminating semicolon to be seen as a terminator.