What is the difference between precision and scale?

by

Precision 4, scale 2: 99.99

Precision 10, scale 0: 9999999999

Precision 8, scale 3: 99999.999

Precision 5, scale -3: 99999000

More Related Contents:

  1. Oracle JDBC and Oracle CHAR data type
  2. Calculate difference between 2 date / times in Oracle SQL
  3. Can you SELECT everything, but 1 or 2 fields, without writer’s cramp?
  4. How to generate entire DDL of an Oracle schema (scriptable)?
  5. How to get records randomly from the oracle database?
  6. Oracle PL/SQL – Raise User-Defined Exception With Custom SQLERRM
  7. Auto Increment for Oracle
  8. Get resultset from oracle stored procedure
  9. Deploying and Configuring ODP.NET to work without installation with Entity Framework
  10. Add a auto increment primary key to existing table in oracle [duplicate]
  11. ways to avoid global temp tables in oracle
  12. Spring Batch ORA-08177: can’t serialize access for this transaction when running single job, SERIALIZED isolation level
  13. How to generate an entity-relationship (ER) diagram using Oracle SQL Developer
  14. String to date in Oracle with milliseconds
  15. Error while trying to retrieve text for error ORA-01804
  16. Create Pivot view in SQL from a SQL table
  17. Does Oracle support full text search?
  18. Oracle.ManagedDataAccess.EntityFramework – ORA-01918: user ‘dbo’ does not exist
  19. Why doesn’t PL/SQL respect privileges granted by Roles?
  20. ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
  21. Can We use threading in PL/SQL?
  22. Speed up to_sql() when writing Pandas DataFrame to Oracle database using SqlAlchemy and cx_Oracle
  23. Is there any way to have the JBoss connection pool reconnect to Oracle when connections go bad?
  24. Get ID of last inserted record in oracle db
  25. oracle SQL plus how to end command in SQL file?
  26. Why is the GETDATE() an invalid identifier
  27. ORA-04091: table [blah] is mutating, trigger/function may not see it
  28. How to use parameters in a ‘where value in…’ clause?
  29. How to generate a version 4 (random) UUID on Oracle?
  30. Find out the history of SQL queries

Leave a Comment