The preference "Mark identifiers longer than 30 characters", despite being checked, does not work on Oracle 12.2 and higher.
Although this seemingly might make sense, since identifier length is enhanced to 128 chars from 12.2 onwards, this causes problems on environments where 12.2+ is a development database while a test database is 12.1.
Also, while the limit in 12.2 is 128 chars, an identifier of length of even 150 characters does not get marked anyway. And that can be considered a bug.
Although this seemingly might make sense, since identifier length is enhanced to 128 chars from 12.2 onwards, this causes problems on environments where 12.2+ is a development database while a test database is 12.1.
Also, while the limit in 12.2 is 128 chars, an identifier of length of even 150 characters does not get marked anyway. And that can be considered a bug.
Last edited:
