Re: Designer 2000 won't let me create integer columns ! ? HELP!

In Oracle server there is no such datatype as an integer, you are only allowed numbers. Number(38) is the default number and there is little point in changing this as all number fields a variable length ( i.e like varchar2)

Integer is use within PLSQL and not within Oracle DDL.

Use NUMBER (38, 0) to ensure that no decimals are inserted.

Keith Kwiatek wrote in message <7b3qj0$2jg$1_at_news.nist.gov>...
>Hello,
>
>I created a server model in designer 2000.
>
>After reviewing it, I noticed that it had changed all my integer types to
>number(38) !?
>
>I went back into the server model and sure enough the column type was
>number(38). So I changed the columns back to integer type... but when I
>generate the DDL, it still shows number(38) ! (although it does stay as
>integer in the server model)
>
>Oddly, I can change the column type to anything BUT integer.
>
>I have requeried the repository....
>
>I have tried deleting/adding the field....
>
>Any other Ideas?
>
>Keith
>
>
Received on Thu Feb 25 1999 - 00:00:00 CET