I think there is a way to get the inserted trailing zeroes in Oracle as well. So if you explicitly inserted 10.0500, you want to get 10.0500 but not 10.05 ?