This week, a short blog on Oracle12c New Features. Oracle12c has extended some common field sizes.
The new field limits are shown in the table below.
Current Table Limit
Current PL/SQL Limit
Oracle12c New Limit
Oracle wanted to make these fields much larger for today’s application requirements and they also wanted to make the sizes consistent between the database objects and the PL/SQL objects.
There is an init.ora setting MAX_STRING_SIZE that is set to EXTENDED to allow these new limits. IF this setting is set to ‘STANDARD’, then the old limits apply. The Oracle12 Release 1 setting is ‘STANDARD’.
Watch for more Oracle12 New Features posts right here.
See you next week.
Dan HotkaOracle ACE Director/Author/Instructor
It isn't as nice as it first sounds because a VARCHAR2 > 4000 will automaticially become a CLOB!