Interested to Buy Any Domain ? << Click Here >> for more details...
2. Display the item number and total cost for each order
line (total cost = no of items X item cost). Name the
calculated column TOTAL COST.
- 2 Answers
- 4691 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / ajit
select itemnum,totalcost
from <tab name>
group by cube(itemnum, totalcost);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to drop an existing view in oracle?
How to convert characters to dates in oracle?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
Explain the difference between sap and oracle?
Explain what are clusters?
What is meant by raw datatype?
Differentiate between translate and replace?
How to drop a tablespace?
How to create a new table in oracle?
What are the different types of synonyms?
How to create a table index in oracle?
What are the various oracle database objects?
how to clone 9i Database on to 10g Database.
What is a sub query? What are its various types?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
