Tipos de Datos en Oracle 10g

[Maxi.Net]

Hola grupo,

Estoy desarrollando un modelo de datos (DER) y quiero dejarlo lo mas fino posible, y para ello me interesa conocer los tipos de datos (Ej.Integer, Varchar2, Date,Numeric, etc.) que soporta Oracle 10g (XE).

He buscado por ahi, y no he encontrado, una lista con la definición de los tipos de datos.

Agradeceria información con respecto a los tipos de datos.

Saludos y gracias

[nomemolestes]

Iniciado por Maxi.Net

Hola grupo,

He buscado por ahi, y no he encontrado, una lista con la definición de los tipos de datos.

Pues debes buscar mejor

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm

Saludos

[Maxi.Net]

Hey gracias pero,
Busco algo mas asi:

#TIPOS DE DATOS EN MYSQL
TinyInt: es un número entero con o sin signo. Con signo el rango de valores válidos va desde -128 a 127. Sin signo, el rango de valores es de 0 a 255

Bit ó Bool: un número entero que puede ser 0 ó 1

SmallInt: número entero con o sin signo. Con signo el rango de valores va desde -32768 a 32767. Sin signo, el rango de valores es de 0 a 65535.

MediumInt: número entero con o sin signo. Con signo el rango de valores va desde -8.388.608 a 8.388.607. Sin signo el rango va desde 0 a16777215.

Integer, Int: número entero con o sin signo. Con signo el rango de valores va desde -2147483648 a 2147483647. Sin signo el rango va desde 0 a 429.4967.295
...
...

Saludos

[PequeñoMauro]

Bueno, aqui te lo dejo, pero en inglés.
Saludos

Código:

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 precision specified. 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 to UTC, 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 Unicode character 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 the functionality 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.