Ask a Teacher

Search



WHILE USING NUMBER IN SQL IT SHOWS ERROR THEN I USE INT WHAT Is The REMEDY For It

In Oracle, an INTEGER is an ANSI SQL data type which refers to numeric values which have only an integer portion and no floating point or decimal part. That is, an INTEGER will only store whole numbers, such as 5, 93, 1816. An INTEGER cannot store '12.85', or any number with a decimal component. If a number with a decimal component is stored as an INTEGER, Oracle will truncate the number. Storing '12.85' as an INTEGER will result in the number being stored aas '12'.

In Oracle, the INTEGER datatype is usually referred to as NUMBER(38). Its precision can range from 1 to 38. 


comments powered by Disqus