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
- 5584 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 |
Explain the use of tables option in exp command.
Explain the use of parfile option in exp command.
Explain the dml?
What is instant client oracle?
Which environment variables are absolutely critical in order to run the OUI?
Does rowid change in oracle?
How can I see all tables in oracle?
What are the system predefined user roles?
What happens if the update subquery returns multiple rows?
What is an Oracle sequence?
Explain enable novalidate constraint.
where do i find oracle interview questions.
Oracle General 
