Oracle-How to check if max_string_size is standard or extended

If you need to find the results via a query you could use....

SELECT name, value
  FROM v$parameter
 WHERE name = 'max_string_size'

You could try to use:

show parameter max_string_size

The value could be STANDARD or EXTENDED. You could find some useful information here.