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 | | |