What is the default Precision and Scale for a Number in Oracle?

by

NUMBER (precision, scale)

If a precision is not specified, the column stores values as given. If no scale is specified, the scale is zero.

A lot more info at:

http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/datatype.htm#CNCPT1832

More Related Contents:

  1. Can we update primary key values of a table?
  2. Oracle (ORA-02270) : no matching unique or primary key for this column-list error
  3. How to display table data more clearly in oracle sqlplus
  4. Liquibase lock – reasons?
  5. How SID is different from Service name in Oracle tnsnames.ora
  6. Are foreign keys really necessary in a database design?
  7. Is it possible to generate django models from the database?
  8. What is a View in Oracle?
  9. What is the difference between Non-Repeatable Read and Phantom Read?
  10. Business Logic: Database or Application Layer
  11. Convert String ISO-8601 date to oracle’s timestamp datatype
  12. Oracle: How do I convert hex to decimal in Oracle SQL?
  13. Difference between partition key, composite key and clustering key in Cassandra?
  14. Spring Security 3 database authentication with Hibernate
  15. Is it fine to have foreign key as primary key?
  16. What is the best way to keep passwords configurable, without having them too easily available to the casual human reader?
  17. How to get english language word database? [closed]
  18. SQL recursive query on self referencing table (Oracle)
  19. Why use a 1-to-1 relationship in database design?
  20. What is the optimal length for an email address in a database?
  21. Non-Relational Database Design [closed]
  22. How can I find MAX with relational algebra?
  23. There is already an object named in the database
  24. How to store images in your filesystem
  25. PostgreSQL Database Log Transaction
  26. In SQL Server, how can I lock a single row in a way similar to Oracle’s “SELECT FOR UPDATE WAIT”?
  27. List of standard lengths for database fields
  28. How to get item count from DynamoDB?
  29. Query a Table’s Foreign Key relationships
  30. Pros/cons of document-based databases vs. relational databases

Leave a Comment