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
- 5653 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 |
Which Oracle App Is Most Popular One ?
How to handle a single quote in oracle sql?
What is java oracle used for?
Tell me New Feature of Oracle 10g?
How to create tables for odbc connection testing?
What is an oracle wallet?
Explain the difference between replace() and translate() functions in oracle?
which sql command we can use to get a print out from oracle?
create one table to capture an employee details with a primary key.
What is memory advisor in Oracle?
How to use attributes of the implicit cursor in oracle?
How to define a specific record type?
Oracle General 
