语法:LENGTH(字符串)
VSIZE(字符串)取字节数
SCOTT@itkaifang> SELECT LENGTH(ename),empno FROM emp; LENGTH(ENAME) EMPNO ------------- ---------- 5 7369 5 7499 4 7521 5 7566 6 7654 5 7698 5 7782 5 7788 4 7839 6 7844 5 7876 5 7900 4 7902 6 7934 14 rows selected. SCOTT@itkaifang> SELECT LENGTH(empno),ename FROM emp; LENGTH(EMPNO) ENAME ------------- ---------- 4 SMITH 4 ALLEN 4 WARD 4 JONES 4 MARTIN 4 BLAKE 4 CLARK 4 SCOTT 4 KING 4 TURNER 4 ADAMS 4 JAMES 4 FORD 4 MILLER 14 rows selected. SCOTT@itkaifang>
SCOTT@itkaifang> SELECT VSIZE(ename) FROM emp; VSIZE(ENAME) ------------ 5 5 4 5 6 5 5 5 4 6 5 5 4 6 14 rows selected. SCOTT@itkaifang>