Supriya

• Aug 16th, 2006

 

Yes,

we can declare a column with above condition.

table created successfully.

Oracle_learner

• Sep 20th, 2006

 

Yes ,such declaration is possible .Explaining with example .1.number(9,11) means there are 11 digits after decimal .However as the max precision is 9 so the rest are zero padded .Like 0.009999999992.number(9,-11) means that there are 9 digits whereas the rest is zero padded towards left of the decimal point Like 99999999900000000000.0

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• May 8th, 2008

 

SQL> create table a2(a number(10,100));
Table created.

SQL> create table a3(a number(10,-84));

Table created.