VSIZE
Syntax
Purpose
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帮助写得很笼统,例子也不好
测试了一下没发现规律
SQL> select vsize(0) from dual; VSIZE(0)
---------
1SQL> select vsize(1) from dual; VSIZE(1)
---------
2
SQL> select vsize(1000) from dual;VSIZE(1000)
-----------
2SQL> select vsize(1001) from dual;VSIZE(1001)
-----------
3SQL> select vsize(1000000000000) from dual;VSIZE(1000000000000)
--------------------
2SQL> select vsize(-1) from dual;VSIZE(-1)
---------
3SQL> 关注!
Syntax
Purpose
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帮助写得很笼统,例子也不好
测试了一下没发现规律
SQL> select vsize(0) from dual; VSIZE(0)
---------
1SQL> select vsize(1) from dual; VSIZE(1)
---------
2
SQL> select vsize(1000) from dual;VSIZE(1000)
-----------
2SQL> select vsize(1001) from dual;VSIZE(1001)
-----------
3SQL> select vsize(1000000000000) from dual;VSIZE(1000000000000)
--------------------
2SQL> select vsize(-1) from dual;VSIZE(-1)
---------
3SQL> 关注!
解决方案 »
- 创建表提示出错
- 为什么所有的数据库规范说明文档里面,都说了关键字要大写?
- 将windows下面的oracle数据导入到unix下面的oracle应该注意哪些
- 关于alter database backup controlfile to trace的问题
- oracle执行计划中的bytes 问题
- 求一条sql语句
- 关于 log sequence number
- 求一条SQL语句,大哥哥们帮帮忙了啦
- 关于表分区中maxvalues的大小?
- 用user_constraints,user_cons_columns来取表之间的连接关系问题!!高分求救
- Oracle8i(1.7.0)装到61%不动了?????????急!!!!!!!!!!!!
- insert或者delete一个表中的记录,报索引错误,前辈帮一下
vsize(1) = 2
vsize(10) = 2
vsize(11) = 2
vsize(100) = 2
vsize(101) = 3
vsize(1000) = 2
vsize(1001) = 3
vsize(10000) = 2
vsize(10001) = 4
vsize(100000) = 2
vsize(100001) = 4
vsize(1000000) = 2
vsize(1000001) = 5
vsize(10000000) = 2
vsize(10000001) = 5
vsize(100000000) = 2
vsize(100000001) = 6