select itemnum,totalcost from <tab name> group by cube(itemnum, tot

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.

Question Posted / ajit

Answer Posted / ajit

select itemnum,totalcost
from <tab name>
group by cube(itemnum, totalcost);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the different oracle database objects?

588

Explain the difference between sap and oracle?

577

How can I introduce multiple conditions in like operator?

558

How to create a new table in your schema?

608

What happens to the current transaction if a ddl statement is executed?

580

What is the oracle implicit cursor?

596

Explain oracle left join with an example?

589

How to compare dates in oracle sql?

659

What is query image?

586

Explain the use of record option in exp command.

539

what is difference between sql plus and sql*plus? (not sql and sql plus).

3351

What is partitioned table in Oracle?

639

How to create a stored program unit?

583

What are the ways tablespaces can be managed and how do they differ?

1618

State the various uses of dbcc command?

551