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?
>

Not as far as I know. (But then, I know not that much.)

> However, my Oracle9i does not even accept SQL statements involving
> types like "smallint unsigned". Is this normal or am I doing something
> wrong?
>

You could post your statement, might be enlightening.

Try, for example: http://www.techonthenet.com/oracle/datatypes.php

And what for would you need this type? The NUMBER type has a precision of I think 38 digits - so you can even easily store an unsigned int64 (not that I've seen one so far) :)

best,
Martin Received on Thu Jul 13 2006 - 08:14:45 CDT