Tipos de datos en oracle

Oracle





VARCHAR2 : Variable-length character data from 1 byte to 4KB. The data is stored in the database character set.
NVARCHAR2 : As VARCHAR2 but the data is stored in the alternative national language character set: one of the permitted Unicode character sets.CHAR : Fixed-length data in the database character set. If the data is not the length of the column, then it will be padded with spaces.
RAW : Variable-length binary data from 1 byte to 2KB. Unlike the CHAR and VARCHAR datatypes, RAW data is not converted by Oracle Net from the database’s character set to the user process’s character set on select or the other way on insert.NUMBER : Numeric data for which you can specify precision and scale. The precision can range from to 1 to 38, and the scale can range from –84 to 127.
FLOAT : This is an ANSI datatype, for floating-point numbers with precision of 126
binary (or 38 decimal). Oracle also provides BINARY_FLOAT and BINARY_DOUBLE as alternatives.INTEGER : Equivalent to NUMBER, with scale zero.
DATE : This is either length zero, if the column is empty, or 7 bytes. All DATE data includes century, year, month, day, hour, minute, and second. The valid range is from January 1, 4712 B.C. to December 31, 9999 A.D.
TIMESTAMP : This is length zero if the column is empty, or up to 11 bytes depending on the precisionspecified. Similar to DATE, but with precision of up to nine decimal places for the seconds, six places by default.
TIMESTAMP WITH TIMEZONE As TIMESTAMP : but the data is stored with a record kept of the time zone to which it refers. The length may be up to 13 bytes depending on precision. This datatype lets Oracle determine the difference between two times by normalizing them toUTC, even if the times are for different time zones.
TIMESTAMP WITH LOCAL TIMEZONE : As TIMESTAMP, but the data is normalized to the database time zone on saving. When retrieved, it is normalized to the time zone of the user process selecting it.
INTERVAL YEAR TO MONTH : Used for recording a period in years and months between two DATEs or TIMESTAMPs.INTERVAL DAY TO SECOND : Used for recording a period in days and seconds between two DATEs or TIMESTAMPs.
CLOB : Character data stored in the database character set, size effectively unlimited: 4GB multiplied by the database block size.
NCLOB : As CLOB, but the data is stored in the alternative national language character set: one of the permitted Unicodecharacter sets.
BLOB : As CLOB, but binary data that will not undergo character set conversion by
Oracle Net.
BFILE : A locator pointing to a file stored on the operating system of the database
server. The size of the files is limited to 4GB.
LONG : Character data in the database character set, up to 2GB. All thefunctionality of LONG (and more) is provided by CLOB; LONGs should not be used in a modern database, and if your database has any columns of this type, they
should be converted to CLOB.
LONG RAW : As LONG, but binary data that will not be converted by Oracle Net. Any LONG RAW columns should be converted to BLOBs.
.

TIPOS DE DATOS EN ORACLE
Os mostramos los tiposde datos / datatypes disponibles en Oracle para seleccionar el tipo de registro de una tabla Oracle. Tamibén indicamos sus características (tamaño máximo, peculiaridades, etc). Es importante conocer los tipos de datos disponibles en un Sistema Gestor de Base de Datos (SGBD), de esta forma podremos obtimizar al máximo el uso de recursos de nuestras aplicaciones. A continuación os indicamos todos...