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

2 Answers
4764 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

Please Help Members By Posting Answers For Below Questions

What is oracle analytical function?

1108

What is oracle rownum?

930

How to view existing locks on the database?

1030

How do I start tns listener?

1025

Difference between cartesian join and cross join?

1009

Explain oracle insert into command?

1084

What is the use of file param in imp command?

1146

How to convert times to characters in oracle?

1011

What is oracle rowcount?

1063

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1823

What is max rowid in oracle?

1001

How to delete a column in an existing table in oracle?

1048

What is the data pump import utility?

1015

Explain the use of record option in exp command.

985

What do you know about normalization? Explain in detail?

933