Oracle SQL Numeric Data Types | Oracle SQL fundamentals

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

Helpful, thanks!

can you please tell me "@.#,$ &,!" are numeric data or non nemeric data

Very helpful 👍 thank you

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 ?

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

Lucid Explanation.. Thank you So much, sir!

Thank you very much

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

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