DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Vsize and Length

  1. #1
    Join Date
    Jan 2004
    Posts
    25

    Vsize and Length

    Hi All,

    What is the difference between Vsize and Length function.

    Both give the same result when i select something.

    Thanx in advance.

  2. #2
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    For more info. go thru SQL Reference

    VSIZE

    Purpose
    VSIZE returns the number of bytes in the internal representation of expr. If expris
    null, then this function returns null.

    Examples
    The following example returns the number of bytes in the last_name of the
    employee in department 10:

    SELECT last_name, VSIZE (last_name) "BYTES"
    FROM employees
    WHERE department_id = 10;
    LAST_NAME BYTES
    --------------- ----------
    Whalen 6

    +++++++++++++
    LENGTH

    Purpose
    The "length" functions return the length of char. LENGTH calculates length using
    characters as defined by the input character set. LENGTHB uses bytes instead of
    characters. LENGTHC uses Unicode complete characters. LENGTH2 uses UCS2
    codepoints. LENGTH4 uses UCS4 codepoints.
    char can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or
    NCLOB. The return value is of datatype NUMBER. If char has datatype CHAR, then
    the length includes all trailing blanks. If char is null, then this function returns
    null.

    Examples
    The following example uses the LENGTH function using a single-byte database
    character set.
    SELECT LENGTH(’CANDIDE’) "Length in characters"
    FROM DUAL;
    Length in characters
    --------------------
    7
    This example assumes a double-byte database character set.
    SELECT LENGTHB (’CANDIDE’) "Length in bytes"
    FROM DUAL;
    Length in bytes
    ---------------
    14
    Cheers!
    OraKid.

  3. #3
    Join Date
    Jan 2004
    Posts
    25
    Hi Balaji,

    Thanx for ur reply.

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