Mega Code Archive

Aligning decimals

SQL> SQL> CREATE TABLE product ( 2 product_name VARCHAR2(25), 3 product_price NUMBER(4,2), 4 quantity_on_hand NUMBER(5,0), 5 last_stock_date DATE); Table created. SQL> SQL> INSERT INTO product VALUES ('Small Widget', 99, 1, '15-JAN-03'); 1 row created. SQL> INSERT INTO product VALUES ('Medium Widget', 75, 1000, '15-JAN-02'); 1 row created. SQL> INSERT INTO product VALUES ('Product Number', 50, 100, '15-JAN-03'); 1 row created. SQL> INSERT INTO product VALUES ('Round Church Station', 25, 10000, null); 1 row created. SQL> SQL> SQL> SELECT * FROM product; PRODUCT_NAME PRODUCT_PRICE QUANTITY_ON_HAND LAST_STOC ------------------------- ------------- ---------------- --------- Small Widget 99 1 15-JAN-03 Medium Widget 75 1000 15-JAN-02 Product Number 50 100 15-JAN-03 Round Church Station 25 10000 SQL> SQL> COLUMN product_price FORMAT 9999.99 SQL> SQL> SELECT * FROM product; PRODUCT_NAME PRODUCT_PRICE QUANTITY_ON_HAND LAST_STOC ------------------------- ------------- ---------------- --------- Small Widget 99 1 15-JAN-03 Medium Widget 75 1000 15-JAN-02 Product Number 50 100 15-JAN-03 Round Church Station 25 10000 SQL> SQL> SQL> DROP TABLE product; Table dropped.