select 5.1d, 42f from dual; : Number « SQL Data Types « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. SQL Data Types
  3. Number
SQL>
SQL> select 5.1d, 42f from dual;

      5.1D        42F
---------- ----------
  5.1E+000   4.2E+001

SQL>








10.9.Number
10.9.1.Number column
10.9.2.Plus two number type columns together
10.9.3.Compare Number type in where clause
10.9.4.NUMBER data type
10.9.5.NUMBER datatype: PRECISION 5 SCALE 2
10.9.6.NUMBER(4,2) as column type
10.9.7.select 5.1d, 42f from dual;
10.9.8.Use IN for number value