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.
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
What are the different oracle database objects?
Explain the difference between sap and oracle?
How can I introduce multiple conditions in like operator?
How to create a new table in your schema?
What happens to the current transaction if a ddl statement is executed?
What is the oracle implicit cursor?
Explain oracle left join with an example?
How to compare dates in oracle sql?
What is query image?
Explain the use of record option in exp command.
what is difference between sql plus and sql*plus? (not sql and sql plus).
What is partitioned table in Oracle?
How to create a stored program unit?
What are the ways tablespaces can be managed and how do they differ?
State the various uses of dbcc command?