Until Oracle 11g SQL, the maximum precision allowed for a string type column was 4000. In Oracle 12c, the precision has been increased up to 32767 bytes or 32K. The new string data types will be known as Extended String Types in Oracle 12c. The feature is controlled by an initialization parameter MAX_STRING_SIZE. The database must be in upgrade mode to enable this feature.
Note that once the feature is enabled, thereafter the parameter cannot be disabled.
ALTER SYSTEM SET max_string_size = ENABLED;
This will increase the use of varchar2 data type in our applications.
No comments:
Post a Comment