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
5500 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

Explain the dml?

921

What is an oracle data file?

1039

How to resolve name conflicts between variables and columns?

982

How to connect to a remote server?

1054

What are the uses of linked server and explain it in detail?

1004

How can I get column names from a table in oracle?

985

How to use "out" parameter properly?

1028

How to assign data of the deleted row to variables?

1015

State and explain the different types of data models?

896

What is proxy method?

931

What is the dynamic sql in oracle?

1008

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2332

Hi Can any one tell me what are the API's used in requisition import.

1881

How to convert times to characters in oracle?

978

What's dateware house and what's clustor with practicle example

2128