Select Item_Name, Item_Cost, Round(Item_Cost, -2) Hundred

14. Display the item_cost and then round it to the nearest
hundred, ten, unit, tenth and hundredth

Question Posted / anuradha

1 Answers
5654 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / anuradha

Select Item_Name,
Item_Cost,
Round(Item_Cost, -2) Hundred_Round,
Round(Item_Cost, -1) Ten_Round,
Round(Item_Cost, 0) Unit_Round,
Round(Item_Cost, 1) Tenth_Round,
Round(Item_Cost, 2) Hundredth_Round
From Items;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to return top 5 rows in oracle?

1115

What are the predefined tablespaces in a database?

1145

What is a sub query? What are its various types?

1278

How to commit the current transaction in oracle?

1188

How do I spool in oracle?

1065

How to work with data objects interactively?

1043

What privilege is needed for a user to create views in oracle?

1094

How to assign values to data fields in record variables?

1080

How do I start tns listener?

1099

WHAT IS ecc 6.0

2205

What are the limitations oracle database 10g xe?

1097

How to select an oracle system id (sid)?

1123

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1442

Does oracle partitioning improve performance?

1053

How do we display rows from the table without duplicates?

1019