如何获取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