Well I found out the default decimal precision is zero so number(10)=number(10,0) should work in your case.

What is your insert statement?


>hi,
>thanx for u r reply
>but i have not given any field width while creating a table
>so what will be the default width for Number and i tried with giving the width also like Number(10,1) so.. but then to its of no use
>so tell me how should i proceed..
>
>amol