14. Display the item_cost and then round it to the nearest
hundred, ten, unit, tenth and hundredth
Answer / 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 |
Where is the export dump file located?
How to pass parameters to procedures in oracle?
What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
How do I limit the number of rows returned by an oracle query after ordering?
What does ROLLBACK do ?
Can a field be used in a report without it appearing in any data group ?
What are different Oracle database objects?
What is an Oracle Instance?
What are the differences between number and binary_float in oracle?
definition of cluster and non-clustered index?
What are the system predefined user roles?
How are the index updates?