Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Query Select

 

Count() and column renaming

SQL> SQL> create table product(   2          product_id          integer     primary key   3          ,price                  number(7,2)   4          ,description            varchar2(75)   5          ,onhand                 number(5,0)   6          ,reorder                number(5,0)   7          ,supplier_no            integer   8  ); Table created. SQL> -- product Table Inserts: SQL> insert into product(product_id, price, description, onhand, reorder)values (1,2.50,'Happy Birthday',100,20); 1 row created. SQL> insert into product(product_id, price, description, onhand, reorder)values (2,23.00,'Happy Birthday',null,null); 1 row created. SQL> insert into product(product_id, price, description, onhand, reorder)values (3,null,'Happy New Year',null,null); 1 row created. SQL> insert into product(product_id, price, description, onhand, reorder)values (4,1.50,'Happy New Year',50,10); 1 row created. SQL> SQL> select count(*) "No. of Products" from product; No. of Products ---------------               4 1 row selected. SQL> SQL> drop table product; Table dropped.