Beta Notes
Code Analysis Rule 2131
Rule 2131 (“Use CONSTANT keyword wherever possible.”) : The suggested hit on line 2 in the example didn’t raise due to the actual example code.
Code Analysis Rule 2757
Rule 2757 (“A CASE expression should have an ELSE clause to avoid it returning NULL”) : Topic text was missing.
Formatter
NOTE: Oracle formatter output may change for a couple of statements due to ongoing work on 12c R2 formatting.
Formatter layout
SELECT Statement: Inconsistent indenting with comment or hint. For instance, line #2 of the following example was shifted one position to the left:
SELECT /*+ hint */
‘abcdef’,
‘bsdfjsdlafkjflasfkjdslffjlsdja’,
‘xsalkfjsdalfjdaslfjdls’,
‘yasjkdfsdjfl’,
‘zklfjdslfjdaslfsajdfl’
FROM dual;
Oracle 12c R2 Support
Support for all new ALTER and CREATE statements.