Newsgroups: comp.databases.oracle.misc Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!colt.net!peernews3.colt.net!newsfeed.stueberl.de!peer01.cox.net!cox.net!border2.nntp.dca.giganews.com!nntp.giganews.com!cyclone1.gnilink.net!gnilink.net!newsfeed3.dallas1.level3.net!news.level3.com!news.sanjose1.Level3.net!Level3.net!news.indiana.edu!news.er.usgs.gov!news From: Brian Peasland Subject: Re: No unsigned in Oracle? In-Reply-To: <1152774655.968110.226090@i42g2000cwa.googlegroups.com> X-Nntp-Posting-Host: edc-cv-160-56.cr.usgs.gov Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-ID: User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) Content-Transfer-Encoding: 7bit Organization: U.S. Geological Survey, Reston VA References: <1152774655.968110.226090@i42g2000cwa.googlegroups.com> Mime-Version: 1.0 Date: Thu, 13 Jul 2006 13:13:19 GMT Lines: 41 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:128494 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@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