What is the difference between DECIMAL and NUMERIC?
It's not clear to me if they're totally interchangeable.
2 answers ( 0 marked as helpful)
to my understanding they can work in the same way, using DECIMAL OR NUMERIC is the same ..in short DECIMAL (7,2) is the same as NUMERIC (7.2)
Thanks for reaching out.
There is one notable difference between NUMERIC and DECIMAL in standard SQL. The NUMERIC data type is strict; it enforces the exact precision and scale that you have specified. This is in stark contrast to DECIMAL, which allows more numbers than the stated precision.
Hope this helps.
Submit an answer
Why did you not do not null, primary key and auto increment for customer id in the solution?
1681 Integer display width is deprecated and will be removed in a future release.