VSIZE

Syntax

Purpose

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

Example

SELECT ename, VSIZE (ename) "BYTES"      
  FROM emp
  WHERE deptno = 10;
 
ENAME           BYTES
---------- ----------
CLARK               5
KING                4
MILLER              6