Number column : Number « SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL Data Types
3. Number

SQL> CREATE TABLE myNumberColumnTable (
  2       product_name  VARCHAR2(25),
  3       product_price NUMBER(4,2));

Table created.

SQL>
SQL> INSERT INTO myNumberColumnTable VALUES ('Product Name 1', 1);

1 row created.

SQL> INSERT INTO myNumberColumnTable VALUES ('Product Name 2', 2.5);

1 row created.

SQL> INSERT INTO myNumberColumnTable VALUES ('Product Name 3', 50.75);

1 row created.

SQL> INSERT INTO myNumberColumnTable VALUES ('Product Name 4', 99.99);

1 row created.

SQL>
SQL> SELECT * FROM myNumberColumnTable;

PRODUCT_NAME              PRODUCT_PRICE
------------------------- -------------
Product Name 1                        1
Product Name 2                      2.5
Product Name 3                    50.75
Product Name 4                    99.99

4 rows selected.

SQL> DROP TABLE myNumberColumnTable;

Table dropped.

SQL>
SQL>