Salam alaykom guys


I have a column for the GPA in a table. The column type is NUMBER (2,2) to be used to enter the Student's GPA (al-mo3adal al-taraakome),but the SQL doest accept values like 3.5 for example.It acceps only values less than 1 (e.g. 0.9). I tried to use DECIMAL(2,2), Numeric(2,2),but still it didnt work....
Any idea?!



Alban

alter table table_name modify field number(11,3)

Mashkoor Yakhee Admin05


alban