I'm not having any luck searching for this question. Is there a way to find the maximum length of a variable in PL/SQL (ORA 9i).
I would like to return the value 75.
I thought perhaps this would work, but no luck.
and LENGTH(sample) only returns the length of the string itself, not what the maximum could be. and MAXLENGTH doesn't seem to exist.
Thanks in advance.