Mega Code Archive

 

Categories / Oracle PLSQL / Select Query

 

All flower product with price range between 10 and 25

SQL> 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 product_id, price, description   2   from product   3  where lower(description) like '%flower%'   4         or price between 10 and 25; PRODUCT_ID      PRICE ---------- ---------- DESCRIPTION ---------------------------------------------------------------------------          2         23 Happy Birthday SQL> SQL> SQL> drop table product; Table dropped.