SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

inserting negative number into a table

682554Apr 2 2009 — edited Apr 2 2009

Hi I am trying ito insert a value of -10.35955056 into a table with data type number (10,10) and this fails with oracle error.

i changed data type to float and when i try to insert I insert the record with no error but the value in the table becomes 0

I hv tried to insert the data again using sign(-1)*10.35955056 , I get Oracle 01722.

Any help please

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 30 2009

Added on Apr 2 2009

4 comments

4,170 views