Re: physical storage of integer datatypes

A copy of this was sent to pjbondi_at_SystemDatabase.com (if that email address didn't require changing) On Mon, 22 Nov 1999 18:35:49 GMT, you wrote:

>Hello to all:
>
>I have used Microsoft SQL Server and Sybase, primarily.
>
>Everything that I have read about Oracle indicates that integer values
>are stored as variable length scientific floating point values.
>
>So could someone positively tell me that there is no such thing in
>Oracle as a:
>- 1 bit "bit" datatype,
>- 2 byte "smallint" datatype
>- 4 byte "int" datatype.
>

in the database -- no, there are no types bit, smallint, int. All numbers are stored in a manner similar to what you describe.

plsql (the language) has a native int type (binary_integer, plsql_integer) and has a boolean type (bit but not bit(4)).

>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Nov 22 1999 - 13:48:48 CST