Hi All,
What is the difference between Vsize and Length function.
Both give the same result when i select something.
Thanx in advance.
Printable View
Hi All,
What is the difference between Vsize and Length function.
Both give the same result when i select something.
Thanx in advance.
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
Hi Balaji,
Thanx for ur reply.