14. Display the item_cost and then round it to the nearest
hundred, ten, unit, tenth and hundredth
- 1 Answers
- 5704 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 |
Can you create a synonym without having a table?
Explain the truncate in oracle?
What is a Private Synonyms ?
Is primary key indexed by default in oracle?
How to join two tables in a single query using oracle?
What is a nested table and how is it different from a normal table?
what is the syntax of ALTER command?
What privilege is needed for a user to insert rows to tables in another schema?
How do I recompile a procedure in oracle?
Explain index?
What is the usage of analyze command in oracle?
What is the function of Optimizer ?
Oracle General 
