Skip to Main Content

FreeSQL

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!

Number with decimal

prashant kanagoMay 17 2026 — edited May 17 2026

Hi All,

I have a column named Price with a decimal place of 2. When I enter record 10.00, it shows only 10. I want the record to save as 10.00. How to do this, please suggest.

When I entered the date as 01-Jan-88, it saved 01/01/2088. How to save the way I entered.

Comments
Post Details
Added on May 17 2026
3 comments
71 views