NUMBER(4,2) as column type : Number « SQL Data Types « Oracle PL/SQL Tutorial

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

SQL>
SQL>
SQL> CREATE TABLE product_order_archive (
  2       product_name  VARCHAR2(25),
  3       salesperson   VARCHAR2(3),
  4       order_date DATE,
  5       quantity      NUMBER(4,2));

Table created.

SQL>
SQL> INSERT INTO product_order_archive VALUES ('Product 1', 'BB', '21-JUN-01', 10);

1 row created.

SQL> INSERT INTO product_order_archive VALUES ('Product 2', 'GA', '22-JUN-02', 50);

1 row created.

SQL> INSERT INTO product_order_archive VALUES ('Product 3', 'LB', '23-JUN-03', 20);

1 row created.

SQL> INSERT INTO product_order_archive VALUES ('Product 4', 'ZZ', '24-JUN-04', 80);

1 row created.

SQL> INSERT INTO product_order_archive VALUES ('Product 5', 'CA', '25-JUN-05', 2);

1 row created.

SQL> INSERT INTO product_order_archive VALUES ('Product 6', 'JT', '26-JUN-06', 50);

1 row created.

SQL>
SQL>
SQL> drop table product_order_archive;

Table dropped.

SQL>