# 5.5.4: Integers still not implimented ...

**URL:** <https://forums.toadworld.com/t/5-5-4-integers-still-not-implimented/3269>\
**Category:** SQL Navigator\
**Created:** [December 4, 2007, 10:55am UTC](https://forums.toadworld.com/t/5-5-4-integers-still-not-implimented/3269 "2007-12-04T10:55:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shannara](https://avatars.discourse-cdn.com/v4/letter/s/6f9a4e/32.png) [@Shannara](https://forums.toadworld.com/u/Shannara)\
**Post date:** [December 4, 2007, 10:55am UTC](https://forums.toadworld.com/t/5-5-4-integers-still-not-implimented/3269/1 "2007-12-04T10:55:56Z")

</div>

This bug existed in 5.5.3 as well, but … I was dumb enough not to report it.

This is majorly messing up all database designs over here. SQL Navigator generates DDLS of tables with integer fields as Number (#,#), which is incorrect in a major way. The other bad thing, is when listing tables with integers, it does the same thing. It replaces Integers with Numbers … not good at all ☹

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [December 5, 2007, 2:24pm UTC](https://forums.toadworld.com/t/5-5-4-integers-still-not-implimented/3269/2 "2007-12-05T14:24:46Z")

</div>

Hi shannara, i have tested this issue on 10g/11g not only in SQL Navigator, but also in Toad and SQL Developer and all those tools behave in the same way as far as INTEGER and NUMBER datatype are concerned, when extracting DDL. We would like to help if we can and need to consult our Oracle experts, but first tell us what is your main concern about this behaviour? Rgds,Andrew Also, see what happened in SQL\*Plus, when I created table withINTEGER: SQL\> create table anawa (col1 INTEGER);

Table created.

SQL\> desc anawa  
Name Null? Type

* * *

COL1 NUMBER(38)

SQL\>

---

<div class="post-metadata">

**Author:** ![piortek](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/piortek/32/70_2.png) [@piortek](https://forums.toadworld.com/u/piortek)\
**Post date:** [December 5, 2007, 4:59am UTC](https://forums.toadworld.com/t/5-5-4-integers-still-not-implimented/3269/3 "2007-12-05T04:59:36Z")

</div>

subtype INTEGER is NUMBER(38,0);

Piter

Hi,  
Oracle SQL does not have simple type INTEGER, this is derivative of number type.  
integer = number(\*,0) so I think this is not error.

Check Oracle package STANDARD, in spec you can find:

* * *