如何获取Oracle中nvarchar2列的大小(以字节为单位)?
问题描述:
嗨朋友们,
我对Oracle完全不熟悉。我想添加一个数据类型为nvarchar(100字节)的列。
我使用了
ALTER TABLE PH_MASTER_STORE添加ADDRESS1 nvarchar2(100)NOT NULL;
它添加了带有nvarchar2(100 Char)的列。如何获得以字节为单位的大小Oracle中的nvarchar2列?请帮帮我.....
提前致谢.....
Vineetha.KR
Hi Friends,
I am totally unfamiliar with Oracle.I want to add a column with datatype nvarchar(100 bytes).
I used
ALTER TABLE PH_MASTER_STORE Add ADDRESS1 nvarchar2(100) NOT NULL;
It added that column with nvarchar2(100 Char).How to get size in bytes of a nvarchar2 column in Oracle? Please help me.....
Thanks in advance.....
Vineetha.K.R
答
选择Sum(DATALENGTH(col))FROM Table
select Sum(DATALENGTH(col)) FROM Table