Re: No unsigned in Oracle?

Jens Lenge wrote:
> Hello world,
>
> am I just too blind or is there really no equivalent to unsigned
> integer types in Oracle?
>
> I understand that Oracle maps all integer data types onto its own
> NUMBER type, yet it does accept ANSI data types in SQL statements and
> does the mapping internally.
>
> However, my Oracle9i does not even accept SQL statements involving
> types like "smallint unsigned". Is this normal or am I doing something
> wrong?
>
> Jens
>

The Oracle SQL Reference document shows the datatypes available in Oracle:

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm#i54335

There is no SMALLINT. This doc even shows that the ANSI SMALLINT datatype is equivalent to NUMBER(38) in Oracle.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown