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.
- 2 Answers
- 4235 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
What is oracle and what are its different editions?
Give the different types of rollback segments.
what is trigger?
How to create a stored program unit?
What is MTTR advisor in Oracle?
What is the data pump export utility?
What is a user role in oracle?
is there a tool to trace queries, like profiler for sql server?
What are a cluster and non-cluster index?
What is a database table in oracle?
What is the difference between RBBMS & DBMS?
20. Using a set operator, display the client number of all clients who have never placed an order.
Oracle General 
