14. Display the item_cost and then round it to the nearest
hundred, ten, unit, tenth and hundredth
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 |
Is it possible to enter only time value into a column of a table in sql?
which language is used to develop the oracle........?
how to genarate random numbers in oracle for particular row?
What is Database Trigger ?
How to turn on or off recycle bin for the session?
What is an UTL_FILE.What are different procedures and functions associated with it?
Explain the use of indexes option in imp command.
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is the function of Optimizer ?
How to write a query with a full outer join in oracle?
How to apply filtering criteria at group level in oracle?
what is the syntax of update command?