oracle中number类型的问题 在oracle中有一个number类型,现在我这样定义两个number类型的,number(1,0) number(38,0)那么,我现在存入数据1到这两个不同的定义中去,那么它们占用的空间一样么? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 -- 占用的空间不一样,同一个字段中的数据不同,占用的空间甚至也不一样,例如:create table t ( x number, y number );insert into t ( x )select to_number(rpad('9', rownum*2,'9'))from all_objectswhere rownum <= 14;update t set y = x+1;set numformat 99999999999999999999999999999col v1 format 99col v2 format 99select x, y, vsize(x) v1, vsize(y) v2from t order by x; X Y V1 V2------------------------------ ------------------------------ --- --- 99 100 2 2 9999 10000 3 2 999999 1000000 4 2 99999999 100000000 5 2 9999999999 10000000000 6 2 999999999999 1000000000000 7 2 99999999999999 100000000000000 8 2 9999999999999999 10000000000000000 9 2 999999999999999999 1000000000000000000 10 2 99999999999999999999 100000000000000000000 11 2 9999999999999999999999 10000000000000000000000 12 2 999999999999999999999999 1000000000000000000000000 13 2 99999999999999999999999999 100000000000000000000000000 14 2 9999999999999999999999999999 10000000000000000000000000000 15 2已选择14行。 请问有first_name last_name时怎么使用nvl方法? 后台数据处理的选择 linux oracle 的操作系统认证(OS认证)在线等待,100分 win7 64 Visual Studio 2008 用oledb连接不到数据库 oracle客户环境的奇怪问题 求一段代码 用C#就好 关于导入外部数据文件 怎么用语句创建用户? 有没有方法在不知道列类型和数量的情况下插入一行? 求救!!!分区表重建索引出错 orange oracle 向上取一位小数
create table t ( x number, y number );insert into t ( x )
select to_number(rpad('9', rownum*2,'9'))
from all_objects
where rownum <= 14;update t set y = x+1;set numformat 99999999999999999999999999999
col v1 format 99
col v2 format 99
select x, y, vsize(x) v1, vsize(y) v2
from t order by x; X Y V1 V2
------------------------------ ------------------------------ --- ---
99 100 2 2
9999 10000 3 2
999999 1000000 4 2
99999999 100000000 5 2
9999999999 10000000000 6 2
999999999999 1000000000000 7 2
99999999999999 100000000000000 8 2
9999999999999999 10000000000000000 9 2
999999999999999999 1000000000000000000 10 2
99999999999999999999 100000000000000000000 11 2
9999999999999999999999 10000000000000000000000 12 2
999999999999999999999999 1000000000000000000000000 13 2
99999999999999999999999999 100000000000000000000000000 14 2
9999999999999999999999999999 10000000000000000000000000000 15 2已选择14行。