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.
Answers were Sorted based on User's Feedback
Answer / girija.112
ANS:
SELECT ITEM_NO , NO_OF_ITEMS*INDIVIDUAL_ITEM_COST AS "TOTAL COST"
FROM ITEM_TABLE
ITEM_NO TOTAL COST
1001 30000
1002 40000
1003 72000
1004 100000
1006 40000
1007 60000
1008 80000
1009 -
1010 56000
I have assumed that ITEM_NO, NO_OF_ITEMS &
INDIVIDUAL_ITEM_COST columns are in a single table ITEM_TABLE
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ajit
select itemnum,totalcost
from <tab name>
group by cube(itemnum, totalcost);
Is This Answer Correct ? | 0 Yes | 0 No |
When can Hash Cluster used ?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Explain the use of rows option in exp command.
How to define a specific record type?
What WHERE CURRENT OF clause does in a cursor?
can a table has a column that has only view data and in other columns we can change data?
What is a trigger and what are its types in oracle?
How will you identify oracle database software release?
How to check the server version in oracle?
What do you mean by redo log file mirroring?
Explain the importance of .pll extension in oracle?
Can you create a synonym without having a table?