14. Display the item_cost and then round it to the nearest
hundred, ten, unit, tenth and hundredth
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
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
How to install oracle database 10g xe?
How index is implemented in oracle database?
what is port in oracle? how is it related to database application.
does the query needs a hint to access a materialized view?
What are the different editions of oracle?
What are the restrictions on external table columns?
Are truncate and delete commands same? If so why?
How to load data from external tables to regular tables?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
how to handle exceptions in post production
What is memory advisor in Oracle?
When system tablespace is created?
What are the ways tablespaces can be managed and how do they differ?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?