Interested to Buy Any Domain ? << Click Here >> for more details...
14. Display the item_cost and then round it to the nearest
hundred, ten, unit, tenth and hundredth
- 1 Answers
- 5597 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
what are bitmap indexes? How does they work?
What is a connect identifier?
Can multiple columns be used in group by in oracle?
What are the oracle differences between nvl and coalesce
How does Oracle guarantee data integrity of data changes?
What is a materialised view?
What is recovery manager(rman) backup in Oracle?
How to define a sub function?
Is a rollback possible to any savepoint?
What is the maximum number of CHECK constraints that can be defined on a column ?
How to create a new table by selecting rows from another table?
What privilege is needed for a user to create views in oracle?
Oracle General 
