Does Oracle store trailing zeroes for Number data type?

by

The existence of the trailing zeros is a display issue, not a storage issue. The trailing zeros are not significant, and anyway the internal format of the numbers is immaterial as long as the values are correct. There is no value difference between 10 and 10.00000.

If you need trailing zeros you can always use formatting when converting the values for display. For example:

System.out.printf("%10.4d\n", decimalValue);

If the problem is differences in scale, you can set the scale to the appropriate value before comparing.

More Related Contents:

  1. How do I limit the number of rows returned by an Oracle query after ordering?
  2. How to create id with AUTO_INCREMENT on Oracle?
  3. When do I need to use a semicolon vs a slash in Oracle SQL?
  4. Is there an Oracle SQL query that aggregates multiple rows into one row? [duplicate]
  5. How to handle a single quote in Oracle SQL
  6. Select count(*) from multiple tables
  7. Fetch the rows which have the Max value for a column for each distinct value of another column
  8. REGEX to select nth value from a list, allowing for nulls
  9. Difference between BYTE and CHAR in column datatypes
  10. Call a stored procedure with another in Oracle
  11. SQL – How to select a row having a column with max value [duplicate]
  12. create table with sequence.nextval in oracle [duplicate]
  13. Oracle: loading a large xml file?
  14. IF EXISTS condition not working with PLSQL
  15. Group by alias (Oracle)
  16. Using pivot on multiple columns of an Oracle row
  17. Check if current date is between two dates Oracle SQL
  18. Benefits Of Using SQL Ordinal Position Notation?
  19. ORA-00907: missing right parenthesis
  20. How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?
  21. Foreign Key Creation issue in Oracle
  22. create custom function for date difference excluding weekends and holidays in oracle sql
  23. How do I list all tables in a schema in Oracle SQL?
  24. Is there a version control system for database structure changes?
  25. oracle sql: update if exists else insert [duplicate]
  26. Oracle: Updating a table column using ROWNUM in conjunction with ORDER BY clause
  27. How to replace specific values in a oracle database column?
  28. ORA-01861: literal does not match format string
  29. Backup SQL Schema Only?
  30. IN vs OR of Oracle, which faster?

Leave a Comment