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
- 5523 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 is oracle sid?
What is not equal to in oracle?
How do you store pictures in a database?
How to import one table back from a dump file?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to sort the query output in oracle?
Explain alias?
How many types of database triggers exist?
What is an anonymous block?
What are a collation and state the different types of collation sensitivity?
what is data abstraction
am completed mca2011 how get certification in oracle
Oracle General 
