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>