Round price as new price : ROUND « Numeric Math Functions « Oracle PL / SQL






Round price as new price

 

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 description, round(price) as price
  2    from product;

DESCRIPTION
---------------------------------------------------------------------------
     PRICE
----------
Happy Birthday
         3

Happy Birthday
        23

Happy New Year


Happy New Year
         2


4 rows selected.

SQL>
SQL> drop table product;

Table dropped.

   
  








Related examples in the same category

1.ROUND: Returns the number rounded to nearest value (precision adjustable)
2.Syntax: ROUND(,)
3.Specifying negative precision will round numbers on the left side of the decimal point, as shown here:
4.ROUND(5.75)
5.Simple demo for ROUND: round a number
6.ROUND with precision
7.ROUND(44.647, -1)
8.ROUND(Number,1): round values from column
9.ROUND(Number,0)
10.ROUND(Number,-1)
11.Round an AVG function
12.Use ROUND function in PL/SQL
13.round Demo
14.Round date to day
15.Round result from months_between
16.Rounding Up and Down
17.Rounds 7:45:26 P.M. on May 25, 2005, to the nearest hour
18.Rounds May 25, 2005, to the first day in the nearest month