Precision of Number is 0?
I used the sample from from http://www.oracle.com/technology/sample_code/tech/java/codesnippet/jdbc/OracleResultSetMetaData.html) to fetch metadata of a table, and the result is:
Number of Columns in the table : 2
Column Name :SysIterID
Column Type :NUMBER
Column Scale :0
Column Precision :19
NULLABLE
Column Name :a
Column Type :NUMBER
Column Scale :0
Column Precision :0 (In SQL Developer it's NUMBER(10,0).)
NOT NULL
From docs, precision of NUMBER should be in range [1,38].
Is it normal to get a 0 precision?
On what condition a 0 presicion is expected?