Home > Database > Mysql Tutorial > Oracle number date varchar2字段类型占用空间大小

Oracle number date varchar2字段类型占用空间大小

WBOY
Release: 2016-06-07 17:38:08
Original
1777 people have browsed it

oracledate类型占用存储空间是7个字节oraclevarchar2类型占用存储空间是每个字符占用一个字节oraclenumber类型占用存储空间是几个字节number最少占用两个字节,

oracle date类型占用存储空间是7个字节


oracle varchar2类型占用存储空间是每个字符占用一个字节


oracle number类型占用存储空间是几个字节

number最少占用两个字节,以后每增加两位数就增加一个字节,,最多占用21个字节

例 NUMBER(20)

计算方式

select floor((20+1)/2)+1 from dual;

FLOOR((20+1)/2)+1

-----------------

11


oracle number date varchar2


Leonarding

2013.11.06

北京&autumn

分享技术~成就梦想

Blog:



本文出自 “分享技术~成就梦想” 博客,请务必保留此出处

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template