Oracle 12c New Features

Oracle Community

Oracle 12c New Features

Follow / 9.6.2013 at 6:32pm

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.

Database Type

Current Table Limit

Current PL/SQL Limit

Oracle12c New Limit

Varchar2

2K

4K

32K

Nvarchar2

2K

4K

32K

Raw

2K

4K

32K

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 Hotka
Oracle ACE Director/Author/Instructor

1266 1 /
Follow / 7 Sep 2013 at 4:58pm

Hi Dan

It isn't as nice as it first sounds because a VARCHAR2 > 4000 will automaticially become a CLOB!