DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2006

    how to get max length of variable?

    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).

    For instance:

    sample VARCHAR2(75);

    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.


  2. #2
    Join Date
    Jul 2002
    Lake Worth, FL


    What's wrong with looking at the source code?
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.