Comp Sci Insert Data Into SQL Table with Number Datatype

[Crystal037]

Homework Statement

I can't understand what is meant by precision and scale while declaring a variable as number datatype in SQL Oracle. I have created a table example and specified attr1 as number(1,1) datatype. According to my understanding it can take one digit before decimal and 1 digit after decimal.But if I'm trying to insert values like 1.1 it's showing value larger than specified precision allowed for this column. Can u explain if my understanding of precision is correct.

Relevant Equations

create table example(
attr1 number(1,1));

insert into example values(1.1);

 

Advertisement

[Mark44]

The image is too small to be legible.

 

[Crystal037]

The image is too small to be legible.

Referring image isn't necessary I've written the query in relevant equations part

 

Advertisement

[Mark44]

If you want to represent 1.1, you need something like this:
number(2, 1)
The first number (2 here) is the total number of digits. The second number (1 here) is the number of digits to the right of the decimal point.
For more info, see https://www.oracletutorial.com/oracle-basics/oracle-number-data-type/