can any body tell how to insert floating point number in oracle

[vijayakumar durai]

can any body tell how to insert floating point number in oracle?.is there any data type i used number(7,7) and insert value(2.00) it show error precison value is greater








thanks in advance

[Paul Campbell]

vijayakumar durai wrote:can any body tell how to insert floating point number in oracle?.is there any data type i used number(7,7) and insert value(2.00) it show error precison value is greater








thanks in advance

For a floating point storage, do not include precision and scale in your column definition (i.e., instead of number(7,7) define the column as number).

Your insert will work correctly after making the change.