Oracle SQL Numeric Data Types | Oracle SQL fundamentals

Numeric data types are numbers stored in #database #columns. These data types are typically grouped by:
Exact numeric types, #values where the #precision and scale need to be preserved. The exact numeric types are #INTEGER, #BIGINT, #DECIMAL, #NUMERIC, #NUMBER, and #MONEY.
Approximate numeric types, values where the precision needs to be preserved and the scale can be floating. The approximate numeric types are DOUBLE PRECISION, #FLOAT, and REAL.

00:00 NUMBER(p,s)
00:31 NUMBER(p,s) Examples
03:05 INTERGER(n)
04:03 INTERGER(n) Examples

[ashishrai]

superbb your explanation is very good in few minutes hats off

[siddhartharao]

Lucid Explanation.. Thank you So much, sir!

[yashgajewar]

Thanks a lot sir i had a huge doubt in precision and scale

[iram]

12.112 will not throw an error it will round off that value

[tommaxchannelz]

if the qty is 2.00 how to write the preciion and sale for this?

[ektheuncut]

can i use like this data types? 2=300, 5=500, 3=300

[venkatk]

for number(5, 2), is it allow if the value is like 1234.5 since total digits are 5 here,
so is it restricted only max 3 digits before the decimal ?