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 is the data pump import utility?

1074

What is concurrency in oracle?

1057

What is Data Dictionary Cache in Oracle?

1243

Describe an oracle table?

1098

What are data pump export and import modes?

1111

How do you store pictures in a database?

1058

How many memory layers are in the oracle shared pool?

1253

How to return top 5 rows in oracle?

1112

Explain the difference between a procedure and a function?

1240

What are temporal data types in oracle?

1168

How will you write a query to get a 5th rank student from a table student_report?

1918

Explain the different normalization forms?

1157

Explain what are the type of synonyms?

1185

what are the default admin accounts in Oracle 10g ?

1022

Explain what are clusters?

1156