Rounding Problem in number data type
650105May 26 2010 — edited May 26 2010If I have a table with numeric column where the decimal places is set to 2 and if I want to add a records value with more than 2 decimal places. In this case oracle should throw us the error message that “Cannot insert into etc.”. It simply insert the record by applying automatic rounding and does not throws an error.i want it did allow to insert how can it possible
regards