Select Item_Name, Item_Cost, Round(Item_Cost, -2) Hundred

14. Display the item_cost and then round it to the nearest
hundred, ten, unit, tenth and hundredth

Question Posted / anuradha

1 Answers
5585 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to get maxsal , minsal, ename department wise in single query

1549

What is an oracle database table?

1012

How to add another datafile to a tablespace?

1038

What is sharded cluster?

1008

Explain drop constraint oracle?

1057

What is oracle update statement with inner join ?

1055

How a database is related to tablespaces?

1031

How to define an oracle cursor variable?

1027

What is a oracle database?

1053

What is procedure overloading in oracle?

1057

How can we delete duplicate rows in a table?

971

What is the difference between 10g OEM and 11g OEM?

965

Can we commit inside a function in oracle?

962

How to start your 10g xe server from command line?

1070

What is Trigger in Oracle?

1168