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

Can sub procedure/function be called recursively?

737

What is the difference between alert log file and tarce file ?

1846

What is the difference between truncate & delete command?

858

What types of joins are used in writing subqueries?

735

How to drop a stored procedure in oracle?

766

How to unlock the sample user account in oracle?

720

What to do if dba lost the system password?

824

Explain view?

794

can u plz provide me oca sql dumps please i need them

1681

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1785

What is materialized view in Oracle?

826

How to drop an index in oracle?

797

What is merge in oracle?

789

What is the use of file param in imp command?

872

Why packages are used in oracle?

773