Menu
I am new on Oracle and maybe my question is an easiest one however I could not find my answer. I want to check max_string_size. Is there any useful system query ? Kind regards, Thank you.
756
Setting MAX_STRING_SIZE = EXTENDED enables the 32767 byte limit introduced in Oracle Database 12c.
Using the Oracle Mapper with Oracle Integration Extended data types are user-defined types based on the primitive data types boolean, integer, real, string, and date, and the composite type container.
The default precision for this data type is 126 binary, or 38 decimal.
You could try to use:
show parameter max_string_size
The value could be STANDARD or EXTENDED. You could find some useful information here.
151
If you need to find the results via a query you could use....
SELECT name, value
FROM v$parameter
WHERE name = 'max_string_size'
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
