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 |
What are the data types in oracle?
How would you extract DDL of a table without using a GUI tool?
Can u make a synonym for deptno=10 only from emp table.
What privilege is needed for a user to create views in oracle?
How a tablespace is related to data files?
Explain joins in oracle?
What are the execution control statements in oracle?
What are nested tables?
what is insert all statement in sql
which is best insttute for teradata,sybase,mysql,oracle in hyderabad
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
Give the different types of rollback segments.